Re: FW: Duplicate oids!

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:hannu@tm.ee]
Sent: 13 December 2002 11:54
To: Steve King
Cc: 'pgsql-hackers@postgresql.org'
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:    pgsql-hackers@postgresql.org
> > 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 <hannu@tm.ee>

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org