Re: pg_dump with tables created in schemas created by extensions - Mailing list pgsql-hackers

From Jim Nasby
Subject Re: pg_dump with tables created in schemas created by extensions
Date
Msg-id abb09d01-b836-16d4-0ae0-9ffaca7f3393@BlueTreble.com
Whole thread Raw
In response to Re: pg_dump with tables created in schemas created by extensions  (Martín Marqués <martin@2ndquadrant.com>)
List pgsql-hackers
On 8/23/16 3:34 PM, Martín Marqués wrote:
> I found quite some other objects we should be checking as well, but
> this will add some duplication to the tests, as I'd just copy (with
> minor changes) what's in src/bin/pg_dump/t/002_pg_dump.pl
>
> I can't think of a way to avoid this duplication, not that it really
> hurts. We would have to make sure that any new objects added to one
> test, if needed, are added to the other (that's a bit cumbersome).

At one point I had some code that understood what object names (ie: 
AGGREGATE, TABLE, etc) went with what catalog tables, what ones lived 
inside a schema (as opposed to globally), and which ones were 
shared/global (cross-database). I think I needed this for some automatic 
handling of comments, but it's been a while. Maybe something like that 
would help reduce the duplication...
-- 
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com
855-TREBLE2 (855-873-2532)   mobile: 512-569-9461



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: dump/restore doesn't preserve row ordering?
Next
From: Michael Paquier
Date:
Subject: Re: Block level parallel vacuum WIP