"scott.marlowe" <scott(dot)marlowe(at)ihs(dot)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
In response to
pgsql-general by date
|Next:||From: Rory Campbell-Lange||Date: 2004-04-27 22:40:37|
|Subject: Re: PL/SQL question|
|Previous:||From: scott.marlowe||Date: 2004-04-27 20:49:13|
|Subject: Re: Question|