>>>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