28 AM, Achmad Nizar Hidayanto wrote:
Thank you for the comment,
I just wonder, how come i have two identic rows. I have set the
primary key and set it as a unique. That's why i take
a look at ctid (in real, i don't use this id. I just tried to trace
why i have two identic rows. Afte
d, i found that the two identic rows differ in their ctid).
Having this case, can i conclude that postgre cannot guarantee the
uniqueness of primary key? or is it just a bug of old
version of postgre?
Many thanks for your help.
Nizar
=
Tom Lane wrote:
Achmad Nizar Hidayanto <[EM
Dear all,
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