Postgres Pro
Downloads
Home   >   mailing lists

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

From tushar
Subject Re: [HACKERS] pg_dump ignoring information_schema tables which usedin Create Publication.
Date
Msg-id 1f5da713-45f2-988f-4235-6969a601548f@enterprisedb.com
Whole thread Raw
In response to Re: [HACKERS] pg_dump ignoring information_schema tables which used in Create Publication.  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] pg_dump ignoring information_schema tables which used in Create Publication.
Next
From: Kuntal Ghosh
Date:
Subject: Re: [HACKERS] pg_dump ignoring information_schema tables which usedin Create Publication.