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(at)tm(dot)ee]
Sent: 13 December 2002 11:54
To: Steve King
Cc: 'pgsql-hackers(at)postgresql(dot)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(at)postgresql(dot)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(at)tm(dot)ee>

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