Re: System vs non-system casts

From: Andrew - Supernews
Subject: Re: System vs non-system casts
Date: ,
Msg-id: slrnd5mbil.2ilg.andrew+nonews@trinity.supernews.net
(view: Whole thread, Raw)
In response to: System vs non-system casts  ("Jim C. Nasby")
Responses: Re: System vs non-system casts  (Tom Lane)
List: pgsql-hackers

Tree view

System vs non-system casts  ("Jim C. Nasby", )
 Re: System vs non-system casts  (Robert Treat, )
 Re: System vs non-system casts  (Andrew - Supernews, )
  Re: System vs non-system casts  (Tom Lane, )
 Re: System vs non-system casts  ("Michael Paesold", )
  Re: System vs non-system casts  (Alvaro Herrera, )
   Re: System vs non-system casts  (Tom Lane, )
 Re: System vs non-system casts  ("Michael Paesold", )
  Re: System vs non-system casts  (Alvaro Herrera, )
   Re: System vs non-system casts  (Tom Lane, )
    Re: System vs non-system casts  ("Jim C. Nasby", )
 Re: System vs non-system casts  (Andrew - Supernews, )
  Re: System vs non-system casts  (Alvaro Herrera, )
   Re: System vs non-system casts  (Tom Lane, )

On 2005-04-12, Robert Treat <> 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:

From: Christopher Kings-Lynne
Date:
Subject: ISO-8859-1 encoding not enforced?
From: Tom Lane
Date:
Subject: Re: System vs non-system casts