Re: Bug #545: Keyword USER not detected in CREATE VIEW

From: Thomas Lockhart <lockhart(at)fourpalms(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: avi(at)argo(dot)co(dot)il, pgsql-bugs(at)postgresql(dot)org
Subject: Re: Bug #545: Keyword USER not detected in CREATE VIEW
Date: 2001-12-28 21:07:49
Message-ID: 3C2CDF25.5C7DC8C3@fourpalms.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

> > 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.

Sure, but his point is that the resulting view has a column which is
named "user" and which is not directly accessible without using double
quotes.

I'm not sure that would qualify as a bug, but certainly is a gotcha...

- Thomas

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2001-12-28 21:17:35 Re: Bug #545: Keyword USER not detected in CREATE VIEW
Previous Message Tom Lane 2001-12-28 16:49:25 Re: Bug #545: Keyword USER not detected in CREATE VIEW