Ask ctid

From: Achmad Nizar Hidayanto <nizar(at)cs(dot)ui(dot)ac(dot)id>
To: pgsql-general(at)postgresql(dot)org
Subject: Ask ctid
Date: 2008-03-06 10:40:00
Message-ID: 47CFCA00.3060902@cs.ui.ac.id
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 table, i found that the two rows differ in ctid value.
As the impact, my application cannot operate well.

It happened after restarting my server. Anyone can help me how to
solve this problem. Many thanks for your help.

Regards,

Nizar
=====

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2008-03-06 12:50:35 Re: Ask ctid
Previous Message Richard Huxton 2008-03-06 09:17:38 Re: Postgresql Page Layout details