Postgres Pro
Downloads
Home   >   mailing lists

Re: Bug #545: Keyword USER not detected in CREATE VIEW - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Bug #545: Keyword USER not detected in CREATE VIEW
Date
Msg-id 1687.1009558165@sss.pgh.pa.us
Whole thread Raw
In response to Bug #545: Keyword USER not detected in CREATE VIEW  (pgsql-bugs@postgresql.org)
List pgsql-bugs
Tree view 
pgsql-bugs@postgresql.org writes:
>   avi=> create view z as select x as user from y;

> My expected result: an error message in CREATE VIEW

This is not a bug, it is intentional behavior.  "AS" names are not
restricted to be non-reserved words.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Darcy Buskermolen
Date:
Subject: Re: Bug #545: Keyword USER not detected in CREATE VIEW
Next
From: Thomas Lockhart
Date:
Subject: Re: Bug #545: Keyword USER not detected in CREATE VIEW