Re: default to WITHOUT OIDS? - Mailing list pgsql-hackers

From Daniel Kalchev
Subject Re: default to WITHOUT OIDS?
Date
Msg-id 200301130843.h0D8hcs18895@dcave.digsys.bg
Whole thread Raw
In response to Re: default to WITHOUT OIDS?  (Neil Conway <neilc@samurai.com>)
List pgsql-hackers
>>>Neil Conway said:> On Fri, 2003-01-10 at 21:27, Christopher Kings-Lynne wrote:> > So what actually is the point of
OIDsthen?> > My understanding is that they're used to uniquely identify entries in> system catalogs. If there's a good
reasonto make use of OIDs on user> tables, I can't see it...
 

What happens if you have an existing database and want to load new tables, 
that rely on their OIDs (the OIDs of the rows actually) to refer to data in 
other tables (the 'old' way)?

Normally, one would dump the old tables 'with oids' and copy to the new 
database 'with oids'. Chances are, there will be duplicate OIDs in the 
database - in the existing and new tables....

Daniel



pgsql-hackers by date:

Previous
From: Giles Lean
Date:
Subject: Re: sync()
Next
From: Daniel Kalchev
Date:
Subject: Re: default to WITHOUT OIDS?