Re: create table bug with reserved words?

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Chris Storah <cstorah(at)emis-support(dot)demon(dot)co(dot)uk>
Cc: <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: create table bug with reserved words?
Date: 2001-02-15 18:00:17
Message-ID: Pine.LNX.4.30.0102151859220.1211-100000@peter.localdomain
Views: Raw Message | Whole Thread | Download mbox
Lists: pgsql-bugs

Chris Storah writes:

> There seems to be an inconsistency in the parsing of create table (possibly
> other SQL syntax?):
> create table test (call int, end, int, select int);
> Fails with ERROR: parser: parse error at or near "create"

SELECT is a reserved word. The error message just shows that the parser
is significantly confused.

> create table test (call int, end1, int, select1 int);
> Works.
> Call, End and Select are reserved words, but why does 'Call' work and the
> others fail?
> Is this a bug - should the parser cope with any reserved words as
> identifiers?
> Thanks,
> Chris

Peter Eisentraut peter_e(at)gmx(dot)net

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Emily Carl 2001-02-15 20:29:15 Regresstion Tests do not find PGLIB directory
Previous Message Tom Lane 2001-02-15 15:22:41 Re: create table bug with reserved words?