Re: Foreign table permissions and cloning - Mailing list pgsql-hackers

From Greg Stark
Subject Re: Foreign table permissions and cloning
Date
Msg-id BANLkTimyLUN1o1GmxRxROSqWjsavMUEJ9Q@mail.gmail.com
Whole thread Raw
In response to Re: Foreign table permissions and cloning  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Mon, Apr 25, 2011 at 7:02 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Yeah, the existing precedent (not only for GRANT but for some other
> things like ALTER TABLE) is that a command that says "TABLE" is allowed
> to apply to other relation types if it makes sense to apply it.  It's
> only when you name some other object type that we get picky about the
> relkind matching exactly.  This is probably more historical than
> anything else, but it's the precedent and we shouldn't make foreign
> tables be the only thing not following the precedent.

Actually I vaguely remember some earlier pass through this code to
make it more consistent. IIRC we previously had some commands that
could only be done through ALTER TABLE even for things like sequences
and views and other commands that had corresponding ALTER VIEW
commands. I'll try to see if I can dig up the messages on the topic.

--
greg


pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: SQLERRD and dump of variables
Next
From: "Todd A. Cook"
Date:
Subject: Re: "stored procedures" - use cases?