Re: Question

"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