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

create table bug with reserved words?

From: Chris Storah <cstorah(at)emis-support(dot)demon(dot)co(dot)uk>
To: pgsql-bugs(at)postgresql(dot)org
Subject: create table bug with reserved words?
Date: 2001-02-15 13:12:03
Message-ID: C05E7DA1218ED411BF8A00105AC95A8E016A9018@SV-CNTRMAIL (view raw or flat)
Thread:
Lists: pgsql-bugs
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"

	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





Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2001-02-15 15:22:41
Subject: Re: create table bug with reserved words?
Previous:From: pgsql-bugsDate: 2001-02-14 23:00:16
Subject: NOTICE: pg_setlocale()

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