"scott.marlowe" <[EMAIL PROTECTED]> 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

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faqs/FAQ.html

Reply via email to