Re: create view bug

Jefim Matskin <mjefim@sphera.com> wrote:
> My problem is that the  ErWin generates the following syntax
> create view [view name] ( [col1] , [col2] ) as select [s1], [s2]  from
> [table name];
> and as far as I know this is SQL92.

On looking more closely, we *do* support this syntax, and have since
release 7.0.  I was misled by the fact that the on-line documentation
failed to mention it.  (Docs fixed now.)

> One of the column names I need is
> 'primary' - and the creation of the view fails.

The problem here is that PRIMARY is a reserved word in Postgres.
I realize that SQL92 describes it as a non-reserved keyword, but
trying to make it so creates ambiguities in our grammar.  You'll
need to pick a different column name.  Sorry.

            regards, tom lane