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

2017-05-26 Thread Euler Taveira
2017-05-26 17:52 GMT-03:00 Peter Eisentraut < peter.eisentr...@2ndquadrant.com>: > > You cannot publish a system catalog. But a user-created table in > information_schema is not a system catalog. Replication of information_schema tables works. However, pg_dump doesn't include

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

2017-05-26 Thread Peter Eisentraut
On 5/25/17 22:45, Robert Haas wrote: > I guess I'm not convinced that it's really the same. I think we want > to allow users to create views over system objects; our life might be > easier if we hadn't permitted that, but views over e.g. pg_locks are > common, and prohibiting them doesn't seem

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

2017-05-25 Thread Robert Haas
On Thu, May 25, 2017 at 5:06 PM, Peter Eisentraut wrote: > They are the same cases. > > a) Create object in information_schema. > > b) Create another object elsewhere that depends on it. > > c) pg_dump will dump (b) but not (a). > > So the fix, if any, would be

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

2017-05-25 Thread Peter Eisentraut
On 5/25/17 09:55, Robert Haas wrote: > On Thu, May 25, 2017 at 8:32 AM, Peter Eisentraut > wrote: >>> Well, I think if it's not going to work, it should be prohibited, >>> rather than seeming to work but then not actually working. >> >> Here is a similar case

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

2017-05-25 Thread Robert Haas
On Thu, May 25, 2017 at 8:32 AM, Peter Eisentraut wrote: >> Well, I think if it's not going to work, it should be prohibited, >> rather than seeming to work but then not actually working. > > Here is a similar case that pg_dump fails on: > > create table

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

2017-05-25 Thread Peter Eisentraut
On 5/24/17 21:36, Robert Haas wrote: > On Wed, May 24, 2017 at 7:16 PM, Peter Eisentraut > 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

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

2017-05-24 Thread Robert Haas
On Wed, May 24, 2017 at 7:16 PM, Peter Eisentraut 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 >

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

2017-05-24 Thread Peter Eisentraut
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

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

2017-05-22 Thread Kuntal Ghosh
On Mon, May 22, 2017 at 5:22 PM, tushar wrote: > On 05/22/2017 05:12 PM, Kuntal Ghosh wrote: >> >> pg_dump ignores anything created under object name "pg_*" or >> "information_schema". > > In this below scenario , I am able to see - pg_dump catch the information >

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

2017-05-22 Thread tushar
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=# --

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

2017-05-22 Thread Tom Lane
tushar writes: > On 05/22/2017 05:12 PM, Kuntal Ghosh wrote: >> pg_dump ignores anything created under object name "pg_*" or >> "information_schema". > In this below scenario , I am able to see - pg_dump catch the > information of table which is created under

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

2017-05-22 Thread tushar
On 05/22/2017 05:12 PM, Kuntal Ghosh wrote: pg_dump ignores anything created under object name "pg_*" or "information_schema". In this below scenario , I am able to see - pg_dump catch the information of table which is created under information_schema postgres=# create database ntest;

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

2017-05-22 Thread Kuntal Ghosh
Hello, pg_dump ignores anything created under object name "pg_*" or "information_schema". I guess you will not have any "CREATE TABLE" definition as well for information_schema.abc. Related code: else if (strncmp(nsinfo->dobj.name, "pg_", 3) == 0 || strcmp(nsinfo->dobj.name,