Search Results
| Search type | Search syntax |
|---|---|
| Tags | [tag] |
| Exact | "words here" |
| Author |
user:1234 user:me (yours) |
| Score |
score:3 (3+) score:0 (none) |
| Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
| Views | views:250 |
| Code | code:"if (foo != bar)" |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Saves | in:saves |
| Status |
closed:yes duplicate:no migrated:no wiki:no |
| Types |
is:question is:answer |
| Exclude |
-[tag] -apples |
| For more details on advanced search visit our help page | |
Results tagged with revisions-list
Search options not deleted
user 153274
For questions about the public lists of changes made to posts by a site's users. They are available for questions and answers by clicking the "edited X min ago" link, and on tag wikis as "history" and "excerpt history" links.
3
votes
2
answers
155
views
When does a post revision get created, exactly?
I'm wondering when exactly a post revision gets created. I can think of two times:
The instant that a post is made three revisions of the original post are created; one for each of the original titl …
- 959
1
vote
1
answer
43
views
Why does SO keep revisions for when a post gets locked, unlocked, etc...?
I'm wondering why a revision is created when a post is locked, unlocked, protected, unprotected, etc...
What is the benefit of doing this?
- 959
5
votes
1
answer
107
views
What advantages are derived from the revisions schema in its current form?
Why does the revisions schema not store an entire post's contents in a single record, rather creating three records, one for each component of a post?
For example, if the post is of a type question, …
- 959
2
votes
How does the revisions view decide whether to display the post closed notice given the follo...
It took me some hours to figure this out, but after analysing the data-dump I found the answer:
A post is displayed as closed when there is an existing record in the postHistory table with a postHist …
- 959
0
votes
2
answers
93
views
How does the revisions view decide whether to display the post closed notice given the follo...
If you view the history of a closed question you'll see a notice saying:
Post closed as "[close reason]" by [moderator name or user names of the voters].
We know moderators can close any questi …
- 959
3
votes
In which table do tag excerpts get stored?
After digging around the data-dump, I found that excerpts are also stored in the posts table under postTypeId of 4. This still does not explain how a tag-wiki can be referenced by the tag itself. Ther …
- 959
2
votes
1
answer
91
views
In which table do tag excerpts get stored?
Where do tag excerpts get stored? The tag-wiki is stored in the posts table--we know this. I imagine the excerpt column is stored in the tags table, but the data-dump does not reflect this, and if it …
- 959