Re: System vs non-system casts

From: Andrew - Supernews <andrew+nonews(at)supernews(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: System vs non-system casts
Date: 2005-04-12 02:11:33
Message-ID: slrnd5mbil.2ilg.andrew+nonews@trinity.supernews.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 2005-04-12, Robert Treat <xzilla(at)users(dot)sourceforge(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Christopher Kings-Lynne 2005-04-12 02:40:23 ISO-8859-1 encoding not enforced?
Previous Message Robert Treat 2005-04-12 01:23:28 Re: System vs non-system casts