Re: [HACKERS] Odd warning from pg_dump

2016-03-08 Thread Tom Lane
Alvaro Herrera writes: > Tom Lane wrote: >> 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. > Not

Re: [HACKERS] Odd warning from pg_dump

2016-03-08 Thread Alvaro Herrera
Tom Lane wrote: > Stephen Frost 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,

Re: [HACKERS] Odd warning from pg_dump

2016-03-08 Thread Stephen Frost
* Tom Lane (t...@sss.pgh.pa.us) wrote: > Stephen Frost 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, > >

Re: [HACKERS] Odd warning from pg_dump

2016-03-08 Thread Tom Lane
Stephen Frost 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

Re: [HACKERS] Odd warning from pg_dump

2016-03-08 Thread Stephen Frost
* Tom Lane (t...@sss.pgh.pa.us) wrote: > Stephen Frost writes: > > * Tom Lane (t...@sss.pgh.pa.us) wrote: > >> pg_dump: WARNING: typtype of data type "any" appears to be invalid > > > This is fixed in my changes to pg_dump, though I didn't expect you'd be > > able to hit them

Re: [HACKERS] Odd warning from pg_dump

2016-03-08 Thread Tom Lane
Stephen Frost writes: > * Tom Lane (t...@sss.pgh.pa.us) wrote: >> pg_dump: WARNING: typtype of data type "any" appears to be invalid > This is fixed in my changes to pg_dump, though I didn't expect you'd be > able to hit them in released versions and so hadn't been planning

Re: [HACKERS] Odd warning from pg_dump

2016-03-08 Thread Stephen Frost
* Tom Lane (t...@sss.pgh.pa.us) wrote: > In connection with a question on -general, I tried this: > > $ pg_dump -n '*' regression >regression.dump > pg_dump: WARNING: typtype of data type "any" appears to be invalid > pg_dump: WARNING: typtype of data type "anyarray" appears to be invalid >

[HACKERS] Odd warning from pg_dump

2016-03-08 Thread Tom Lane
In connection with a question on -general, I tried this: $ pg_dump -n '*' regression >regression.dump pg_dump: WARNING: typtype of data type "any" appears to be invalid pg_dump: WARNING: typtype of data type "anyarray" appears to be invalid pg_dump: WARNING: typtype of data type "anyelement"