Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
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       http://yi.org/peter-e/


In response to

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group