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 <[EMAIL PROTECTED]> 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


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly

Reply via email to