Re: oh dear - have i messed up my OIDs?

From: "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>
To: brian ally <brian(at)zijn-digital(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: oh dear - have i messed up my OIDs?
Date: 2006-06-28 16:02:13
Message-ID: 20060628160213.GE44573@pervasive.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Nik 2006-06-28 16:05:38 Upgrade problem
Previous Message Bill Eaton 2006-06-28 16:02:04 unusual "relation xxx does not exist" problem