Re: pg_dump ignoring information_schema tables which used in Create Publication.

From: tushar <tushar(dot)ahuja(at)enterprisedb(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Kuntal Ghosh <kuntalghosh(dot)2007(at)gmail(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-22 12:26:22
Message-ID: 1f5da713-45f2-988f-4235-6969a601548f@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 05/22/2017 05:31 PM, Tom Lane wrote:
> Do we have a prohibition against publishing/subscribing anything
> in pg_catalog?
Yes.

postgres=# create publication pub for table pg_catalog.pg_AM;
ERROR: "pg_am" is a system table
DETAIL: System tables cannot be added to publications.
postgres=#

--
regards,tushar
EnterpriseDB https://www.enterprisedb.com/
The Enterprise PostgreSQL Company

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Kuntal Ghosh 2017-05-22 12:34:07 Re: pg_dump ignoring information_schema tables which used in Create Publication.
Previous Message Tom Lane 2017-05-22 12:01:50 Re: pg_dump ignoring information_schema tables which used in Create Publication.