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
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] |