"scott.marlowe" <scott.marlowe@ihs.com> writes:
> When postgresql "deletes" a tuple prior to it being vacuumed, it simply
> sets a time stamp on it that vacuum can use to see it is "deleted" and no
> longer visible. If you are actually getting back tuples with the words
> #Deleted in them, then I would guess you have an application error.
The application in question is almost certainly Microsoft Access--it
has its own weird idea of how to track deleted rows in an ODBC table.
The '#Deleted' phenomenon with Access is fairly common and well
documented.
-Doug