I'm currently using Postgre 8.2. Are there something wrong with that
version?
Below is the DDL for my table:
CREATE TABLE absensi (
id_absensi integer NOT NULL,
id_user integer,
tanggal date,
keterangan character varying,
id_tipe_absensi integer
);
ALTER TABLE ONLY absensi
Achmad Nizar Hidayanto wrote:
The two records are identical. But if i display the ctid, the two
records differ as they
have different ctid (suppose i display the ctid in the first column):
R1: , 1001, 1, 02-25-2008, Present, 1
R2: , 1001, 1, 02-25-2008, Present, 1
This would be a
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. After examining the physical
id using ctid, i found
On Fri, Mar 07, 2008 at 03:28:12PM +0700, Achmad Nizar Hidayanto wrote:
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?
There were some older versions that had some bugs in this area. Whether
this
On Mar 7, 2008, at 9: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
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
On Thu, Mar 06, 2008 at 05:40:00PM +0700, Achmad Nizar Hidayanto wrote:
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
Achmad Nizar Hidayanto [EMAIL PROTECTED] 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