Re: [HACKERS] pg_dump ignoring information_schema tables which usedin Create Publication. - Mailing list pgsql-hackers

From Robert Haas
Subject Re: [HACKERS] pg_dump ignoring information_schema tables which usedin Create Publication.
Date
Msg-id CA+TgmoZy6dcV3=NzXP+ooCV3MkAXP--_uVx1zrCTWs4V0+nXXg@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] pg_dump ignoring information_schema tables which usedin Create Publication.  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
Responses Re: [HACKERS] pg_dump ignoring information_schema tables which usedin Create Publication.  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
List pgsql-hackers
On Thu, May 25, 2017 at 8:32 AM, Peter Eisentraut
<peter.eisentraut@2ndquadrant.com> wrote:
>> Well, I think if it's not going to work, it should be prohibited,
>> rather than seeming to work but then not actually working.
>
> Here is a similar case that pg_dump fails on:
>
> create table information_schema.test1 (a int);
> create view public.test2 as select * from information_schema.test1;
>
> It's not clear how to address that, or whether it's worth it.

Sure, that case is hard to address.  But why is *this* case hard to address?

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



pgsql-hackers by date:

Previous
From: tushar
Date:
Subject: [HACKERS] No parameter values checking while creating Altersubscription...Connection
Next
From: Amit Kapila
Date:
Subject: Re: retry shm attach for windows (WAS: Re: [HACKERS] OK, so culicidaeis *still* broken)