Postgres Pro
Downloads
Home   >   mailing lists

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+TgmoYubaw0gUuafc=A4ge=FqeGKG7CDa8F0dKHaNc81jUJaw@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
Tree view 
On Wed, May 24, 2017 at 7:16 PM, Peter Eisentraut
<peter.eisentraut@2ndquadrant.com> wrote:
> On 5/22/17 07:42, Kuntal Ghosh wrote:
>> pg_dump ignores anything created under object name "pg_*" or
>> "information_schema".
>
> Publications have a slightly different definition of what tables to
> ignore/prohibit than pg_dump, partly because they have more built-in
> knowledge.  I'm not sure whether it's worth fixing this.

Well, I think if it's not going to work, it should be prohibited,
rather than seeming to work but then not actually working.

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

pgsql-hackers by date:

Previous
From: Masahiko Sawada
Date:
Subject: Re: [HACKERS] Improvement in log message of logical replication worker
Next
From: "Tsunakawa, Takayuki"
Date:
Subject: Re: [HACKERS] [PATCH v1] Add and report the new "in_hot_standby"GUC pseudo-variable.