The ctids are different however vaccum is run on this table and the record is updated. The machineid is a SERIAL and so should also never be duplicated.
ctid | oid | machineid --------+---------+----------- (7,18) | 9646238 | 12 (7,10) | 9646238 | 12 Any help as usual is greatly appreciated. -----Original Message----- From: Hannu Krosing [mailto:[EMAIL PROTECTED]] Sent: 13 December 2002 11:54 To: Steve King Cc: '[EMAIL PROTECTED]' Subject: Re: [HACKERS] FW: Duplicate oids! On Fri, 2002-12-13 at 09:27, Steve King wrote: > > -----Original Message----- > > From: Steve King > > Sent: 12 December 2002 11:45 > > To: [EMAIL PROTECTED] > > Subject: Duplicate oids! > > > > Forgive me if this is a previous question but I cannot find any > > information on it in any of the mailing lists. > > > > I have a postgres database that contains a table with two identical > > records including the oid. What about ctid's, are they also the same ? Are the tuples on the same page ? > > It seems as though one insert statement (intending one record to be > > inserted) has caused two identical records to be inserted. > > The insert statement was done via the c++ library. > > > > Does anyone know anything about this? > > > > My info can be supplied if this is not a known problem! > > > > P.S. I am running Postgres 7.2 > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org -- Hannu Krosing <[EMAIL PROTECTED]> ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
