Re: Ask ctid

Achmad Nizar Hidayanto <nizar(at)cs(dot)ui(dot)ac(dot)id> writes:
> I implement database in my faculty using Postgre. I have a problem
> with ctid in my tables. Let say, i have table STUDENT with #STU
> as the primary key. I don't know what happend in this table, some
> rows have exactly the same value ( i also have set the #STU as unique).
> After tracing the table, i found that the two rows differ in ctid value.
> As the impact, my application cannot operate well.

There are some known bugs in older PG releases that could lead to
duplicate rows (actually, to multiple versions of a row all being seen
as live). If you're not on the latest minor version of your release
series, update.

regards, tom lane