Re: oh dear - have i messed up my OIDs? - Mailing list pgsql-general

From Jim C. Nasby
Subject Re: oh dear - have i messed up my OIDs?
Date
Msg-id 20060628160213.GE44573@pervasive.com
Whole thread Raw
In response to oh dear - have i messed up my OIDs?  (brian ally <brian@zijn-digital.com>)
List pgsql-general
On Sun, Jun 25, 2006 at 03:14:41PM -0400, brian ally wrote:
> My question is, can i safely run my modifications again, but swap out
> the INSERTs for the COPY WITH OIDs bit from the dump (adding my new
> INSERTs after)? Would those OIDs still be "good", so to speak?

Probably.

> ANY advice appreciated.

Don't use OIDs, use SERIALs instead. You're going to run into all kinds
of problems using OIDs.
--
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461

pgsql-general by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: Idea for vacuuming
Next
From: "Bill Eaton"
Date:
Subject: unusual "relation xxx does not exist" problem