pg_dump ignoring information_schema tables which used in Create Publication.

From: tushar <tushar(dot)ahuja(at)enterprisedb(dot)com>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: pg_dump ignoring information_schema tables which used in Create Publication.
Date: 2017-05-22 10:52:32
Message-ID: 529a5378-9152-0056-b066-9ec6348b6a2f@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

pg_dump is ignoring tables which created under information_schema
schema for CREATE PUBLICATION .

postgres=# create database test;
CREATE DATABASE
postgres=# \c test
You are now connected to database "test" as user "centos".
test=# create table information_schema.abc(n int);
CREATE TABLE
test=# create publication test for table information_schema.abc;
CREATE PUBLICATION
test=# select * from pg_publication_tables;
pubname | schemaname | tablename
---------+--------------------+-----------
test | information_schema | abc
(1 row)

test=# \q
[centos(at)centos-cpula regress]$ pg_dump -Fp test > /tmp/a.a
[centos(at)centos-cpula regress]$ cat /tmp/a.a|grep publication -i
-- Name: test; Type: PUBLICATION; Schema: -; Owner: centos
CREATE PUBLICATION test WITH (publish = 'insert, update, delete');
ALTER PUBLICATION test OWNER TO centos;
[centos(at)centos-cpula regress]$

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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Kuntal Ghosh 2017-05-22 11:02:21 Re: "create publication..all tables" ignore 'partition not supported' error
Previous Message Sokolov Yura 2017-05-22 10:41:40 Seekable compressed TOAST [POC]