Re: System vs non-system casts - Mailing list pgsql-hackers

From Andrew - Supernews
Subject Re: System vs non-system casts
Date
Msg-id slrnd5mbil.2ilg.andrew+nonews@trinity.supernews.net
Whole thread Raw
In response to System vs non-system casts  ("Jim C. Nasby" <decibel@decibel.org>)
Responses Re: System vs non-system casts  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On 2005-04-12, Robert Treat <xzilla@users.sourceforge.net> wrote:
> One potential ugly way to do it would be to use the magical "last system oid" 
> as a differentiator between those created by pg and those created by the 
> user.  It would be different for every version so that might be a problem. 

That is what pg_dump does when talking to pre-7.2 databases. But it isn't
entirely reliable because oid wrap can allow the user to create objects
with oids < datlastsysoid. (If it was BootstrapOid you were thinking of,
that doesn't work at all because the system casts are added after the
bootstrap stage.) 

-- 
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services


pgsql-hackers by date:

Previous
From: Robert Treat
Date:
Subject: Re: System vs non-system casts
Next
From: Christopher Kings-Lynne
Date:
Subject: ISO-8859-1 encoding not enforced?