Achmad Nizar Hidayanto <nizar@xxxxxxxxxxx> 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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
