Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

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



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



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group