« first day (3013 days earlier)      last day (988 days later) » 

Martin Sleziak
Martin Sleziak
09:59
Does the PostsWithDeleted table keep the tags the way they were at the time of deletion, or are they updated even if the tags are edited after the deletion?
Maybe the easiest way to find out is to make an experiment.
Let us take three deleted posts on Meta Stack Exchange.
379267: use docker build a master-slave database of postgres,but meet a problem
379278: How to modify the Owner information in a PDF file?
379466: How can i reduce my extra width?
The last one was created (and deleted) today - so that one isn't in the database yet.
I created a SEDE query listing the tags for the given questions.
This is what I got as the csv file:
> Tags,Id,Post Link,CreationDate,DeletionDate,LastActivityDate,Revision History
"<support>","379267","379267","2022-06-04 07:47:30","2022-06-04 07:49:56","","site://posts/379267/revisions"
"<support><pdf><metadata>","379278","379278","2022-06-04 16:11:44","2022-06-04 16:44:49","","site://posts/379278/revisions"
And here is a screenshot:
user image
I have added sandbox to each of those questions - and I'll get back and check after the next update of SEDE, whether the tag is shown there or not.

« first day (3013 days earlier)      last day (988 days later) »