Re: Odd warning from pg_dump - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Odd warning from pg_dump
Date
Msg-id 10757.1457453207@sss.pgh.pa.us
Whole thread Raw
In response to Re: Odd warning from pg_dump  (Stephen Frost <sfrost@snowman.net>)
Responses Re: Odd warning from pg_dump
Re: Odd warning from pg_dump
List pgsql-hackers
Stephen Frost <sfrost@snowman.net> writes:
> I think the real question is if "-n '*'" should still exclude
> 'pg_catalog'.  Fixing the issue with defined pseudo types is wonderful,
> but aren't you going to end up with a dump you can't restore,
> regardless?

Yeah, perhaps so.  The thread on -general has also produced the
information that pg_dump -t '*' tries to dump system catalogs as if
they were user tables, which is another pretty useless bit of behavior.
So maybe we should drop the hunk you've got there (which frankly seems a
bit of a kluge) and instead hot-wire things so that stuff in pg_catalog
is excluded even if it would otherwise match the inclusion lists.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Stephen Frost
Date:
Subject: Re: Odd warning from pg_dump
Next
From: Andrew Dunstan
Date:
Subject: Re: VS 2015 support in src/tools/msvc