Re: Re: OID as Primary Key

Can't you do a dump with the oid's?

But when I want to know the primary key of the inserted row
I have to do an extra select query. If I use oid I just use
pg_getlastoid() in php.
And it is redundant data to store another integer.

Comments?

/Jonas B

> Jonas Bengtsson <jonas.b@home.se> writes:
> > I have problems with using OID as PK.
>
> This strikes me as a fairly bad idea in any case.  What
happens if you
> must dump and reload your database?  Better to use a
SERIAL column as
> primary key.
>
>             regards, tom lane
>



Mvh,
Jonas Bengtsson