Could we set a starting OID for user stuff like (0x4000000) or some
other round number?
LER
* Philip Warner <pjw@rhyme.com.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@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749