Re: [COMMITTERS] pgsql: Include foreign tables in information_schema.table_privileges

Robert Haas <robertmhaas@gmail.com>

From: Robert Haas <robertmhaas@gmail.com>

To: Peter Eisentraut <peter_e@gmx.net>

Cc: "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>

Date: 2017-08-16T11:27:42Z

Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Correct representation of foreign tables in information schema
- 9b5140fb503e 11.0 cited
Include foreign tables in information_schema.table_privileges
- 9f0f4efc2f1e 9.3.19 cited
Basic foreign table support.
- 0d692a0dc9f0 9.1.0 cited

On Tue, Aug 15, 2017 at 7:41 PM, Peter Eisentraut <peter_e@gmx.net> wrote:
> Include foreign tables in information_schema.table_privileges
>
> This appears to have been an omission in the original commit
> 0d692a0dc9f.  All related information_schema views already include
> foreign tables.
>
> Reported-by: Nicolas Thauvin <nicolas.thauvin@dalibo.com>

I would have been disinclined to back-patch this.  Somebody could be
depending on the current behavior, and now we'll end up with two kinds
of clusters, one where initdb was done before these changes and
another where it was done afterward.  So nobody will be able to count
on this behavior one way or the other.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company