On 14/03/2010 16:21, fkater(at)googlemail(dot)com wrote:
> (2)
> If I need to go the long way and replace the OIDs with
> SERIALs first, updating all relations to it etc: Would a
> dump/restore then restore the original values in a SERIAL
> column?
So-called SERIAL types are actually just integer columns which take
nextval('some_sequence') as their DEFAULT, so yes - if you first replace
your OIDs with serials, the values will still be there after a dump/restore.
This is probably the more robust way to go long-term.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
rod(at)iol(dot)ie