Re: libpq: usage of PQoidValue to obtain serial primary key after insert - Mailing list pgsql-interfaces

From Peter Eisentraut
Subject Re: libpq: usage of PQoidValue to obtain serial primary key after insert
Date
Msg-id 200407221444.56693.peter_e@gmx.net
Whole thread Raw
In response to libpq: usage of PQoidValue to obtain serial primary key after insert  (Michal Dobaczewski <mdobaczewski@cc.com.pl>)
Responses Re: libpq: usage of PQoidValue to obtain serial primary
List pgsql-interfaces
Am Donnerstag, 22. Juli 2004 13:14 schrieb Michal Dobaczewski:
> Browsing the general list I've just read a post claiming that oid are
> not guaranteed to be unique in the table. This is also stated in the
> documentation - which seems to have escaped me this far. So I assume the
> approach presented above is flawed.
>
> I would like to ask what is a most elegant way to deal with such issues?

Create a unique constraint on the oid column.

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/


pgsql-interfaces by date:

Previous
From: Michal Dobaczewski
Date:
Subject: libpq: usage of PQoidValue to obtain serial primary key after insert
Next
From: Michal Dobaczewski
Date:
Subject: Re: libpq: usage of PQoidValue to obtain serial primary