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