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 information_schema
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 lik
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 to prevent (a), or prevent (b), or f
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 that pg_dump fails on:
>>
>> create ta
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 information_schema.test1 (a int);
> create
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 slightly different definition of what tabl
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
> ignore/prohibit than pg_dump, partly b
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 it'
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
> of table which is created under
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=#
--
reg
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 information_schema
Creating your o
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;
\CREAT
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, "inform
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 TABL
14 matches
Mail list logo