Re: Last builtin OID?

From: Larry Rosenman <ler(at)lerctr(dot)org>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Last builtin OID?
Date: 2000-10-22 01:22:35
Message-ID: 20001021202235.A1169@lerami.lerctr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Could we set a starting OID for user stuff like (0x4000000) or some
other round number?

LER

* Philip Warner <pjw(at)rhyme(dot)com(dot)au> [001021 19:52]:
> At 16:00 21/10/00 +0200, Peter Eisentraut wrote:
> >
> >Perhaps you could move the CREATE TRIGGER pg_sync_pg_pwd (or something
> >else) to the very end to get a more predictable starting point.
> >
>
> Unfortunately, this is the sort of thing that caused the current problem
> (ie. assuming that a certain item of metadata will remain 'at the end').
>
> What pg_dump needs is 'the oid of that the first thing created in a new DB
> will have'. Would there be a simple way of adding a
> variable/attribute/whatever to template1? Or adding something to the code
> for 'Create Database' that sets a global variable that pg_dump can retreieve?
>
>
> ----------------------------------------------------------------
> Philip Warner | __---_____
> Albatross Consulting Pty. Ltd. |----/ - \
> (A.B.N. 75 008 659 498) | /(@) ______---_
> Tel: (+61) 0500 83 82 81 | _________ \
> Fax: (+61) 0500 83 82 82 | ___________ |
> Http://www.rhyme.com.au | / \|
> | --________--
> PGP key available upon request, | /
> and from pgp5.ai.mit.edu:11371 |/
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 (voice) Internet: ler(at)lerctr(dot)org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2000-10-22 01:40:56 Re: Last builtin OID?
Previous Message Tom Lane 2000-10-22 01:08:15 Re: Unable to access CVS server