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 b
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
AD
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 ident
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 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
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 h
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 ha
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
