On Mon, Apr 25, 2011 at 7:02 PM, Tom Lane <t...@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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers