Postgres Pro
Downloads
Home   >   mailing lists

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

From Peter Eisentraut
Subject Re: [HACKERS] pg_dump ignoring information_schema tables which usedin Create Publication.
Date
Msg-id fa4b7f3f-dd59-1a9a-a4a6-b589b5dd6719@2ndquadrant.com
Whole thread Raw
In response to Re: [HACKERS] pg_dump ignoring information_schema tables which usedin Create Publication.  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: [HACKERS] pg_dump ignoring information_schema tables which usedin Create Publication.  (Euler Taveira <euler@timbira.com.br>)
List pgsql-hackers
Tree view 
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 like a reasonable choice.
> I'm less clear that we want to let them publish system objects.  Aside
> from the pg_dump issues, does it work?

The confusion in this discussion is exactly that there are multiple
definitions of what a "system object" might be.

You cannot publish a system catalog.  But a user-created table in
information_schema is not a system catalog.

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: [HACKERS] logical replication and PANIC during shutdowncheckpoint in publisher
Next
From: Peter Eisentraut
Date:
Subject: Re: [HACKERS] ALTER SUBSCRIPTION ..SET PUBLICATION refreshis not throwing error.