[HACKERS] Re: Unhappy thoughts about pg_dump and objects inherited from template1

2000-11-02 Thread Philip Warner
At 20:12 2/11/00 -0500, Tom Lane wrote: >Philip Warner <[EMAIL PROTECTED]> writes: >>> 1. What if the inherited object is a table or a sequence? > >> The only solution I can think of for this would be to use lastsysoid from >> template1; this is the value set when initdb runs. > >How does that hel

[HACKERS] Re: Unhappy thoughts about pg_dump and objects inherited from template1

2000-11-02 Thread Philip Warner
At 19:35 2/11/00 -0500, Tom Lane wrote: >We've hacked up pg_dump so that it won't dump objects inherited from >template1. Unfortunately I have realized there are a couple of serious >problems: > >1. What if the inherited object is a table or a sequence? >2. For that matter, even function definiti

[HACKERS] Re: Unhappy thoughts about pg_dump and objects inherited from template1

2000-11-02 Thread Tom Lane
Philip Warner <[EMAIL PROTECTED]> writes: >> 1. What if the inherited object is a table or a sequence? > The only solution I can think of for this would be to use lastsysoid from > template1; this is the value set when initdb runs. How does that help? It won't tell you anything about updated or