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(dot)b(at)home(dot)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