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

RE: 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: RE: create table bug with reserved words?
Date: 2001-02-16 09:27:43
Message-ID: C05E7DA1218ED411BF8A00105AC95A8E016D0C43@SV-CNTRMAIL (view raw or flat)
Thread:
Lists: pgsql-bugs
According to the documentation, CALL is in as a reserved word (7.1beta4 docs
I think).

The problem I have (and others may get) is porting apps from other databases
that support reserved words as identifiers (SQL server being the main one).

I assume the parser should know where it is (first and follow sets would
define whether a reserved word is allowed or not?), so is there any reason
why an identifier cannot cope with reserved words?.

If not, can anyone point me in the direction of the code that does the
parsing so I can take a look - if this would be helpful!

Thanks,
Chris

-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: 15 February 2001 15:23
To: Chris Storah
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: [BUGS] create table bug with reserved words? 


Chris Storah <cstorah(at)emis-support(dot)demon(dot)co(dot)uk> writes:
> Is this a bug - should the parser cope with any reserved words as
> identifiers?

No, and no.  If you could use them as identifiers then they wouldn't
be reserved words, would they?

Some keywords are "more reserved" than others in the Postgres parser;
see the distinction between ColId and ColLabel in gram.y if you want
the details.  AFAICT, "CALL" is not a keyword at all in Postgres.

			regards, tom lane

Responses

pgsql-bugs by date

Next:From: Henshall, Stuart - WCPDate: 2001-02-16 15:33:48
Subject: Rules for Inserting Serials
Previous:From: Scott WilliamsDate: 2001-02-16 07:51:57
Subject: On NetBSD, had to add -Wl,-R/usr/local/postgres/lib to the src/Makefile.global LIB variable

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