| From: | Robert Haas <robertmhaas(at)gmail(dot)com> |
|---|---|
| To: | Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com> |
| Cc: | Kuntal Ghosh <kuntalghosh(dot)2007(at)gmail(dot)com>, tushar <tushar(dot)ahuja(at)enterprisedb(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: pg_dump ignoring information_schema tables which used in Create Publication. |
| Date: | 2017-05-25 01:36:29 |
| Message-ID: | CA+TgmoYubaw0gUuafc=A4ge=FqeGKG7CDa8F0dKHaNc81jUJaw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Wed, May 24, 2017 at 7:16 PM, Peter Eisentraut
<peter(dot)eisentraut(at)2ndquadrant(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tsunakawa, Takayuki | 2017-05-25 01:38:36 | Re: [PATCH v1] Add and report the new "in_hot_standby" GUC pseudo-variable. |
| Previous Message | Masahiko Sawada | 2017-05-25 01:30:24 | Re: Improvement in log message of logical replication worker |