Re: Unhappy thoughts about pg_dump and objects inherited from template1 - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: Unhappy thoughts about pg_dump and objects inherited from template1
Date
Msg-id Pine.LNX.4.21.0011101722570.775-100000@peter.localdomain
Whole thread Raw
In response to Re: Unhappy thoughts about pg_dump and objects inherited from template1  (Philip Warner <pjw@rhyme.com.au>)
Responses Re: Unhappy thoughts about pg_dump and objects inherited from template1  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Philip Warner writes:

> I think both this and the OID-wrap problem will be permanent features until
> we have a non-oid-based dump procedure. Pretty much every piece of metadata
> needs some kind of 'I am a system object, don't dump me' flag. 

When we implement schemas, then all objects belonging to the
DEFINITION_SCHEMA will not be dumped, all other objects will be.  At least
I imagine that this might be something to work with.

-- 
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/



pgsql-hackers by date:

Previous
From: Dirk Lutzebaeck
Date:
Subject: Re: Must a C state transition function use palloc on the returned value?
Next
From: devik@cdi.cz
Date:
Subject: Re: Query caching