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