Probelm creating a table
"global" is indeed a postgres keyword
refer Postgres User's Guide Chapter 2-"SQL Syntax" in the section Key
words".
The following section gives the answer
The following are Postgres reserved words which are also SQL92 or SQL3
reserved words, and which are allowed to be present as column labels, but
not as identifiers:
On Wed, 23 Aug 2000, Dave Smith wrote:
CASE COALESCE CROSS CURRENT ELSE END FALSE FOREIGN GLOBAL GROUP LOCAL
NULLIF ORDER POSITION PRECISION TABLE THEN TRANSACTION TRUE
WHEN
Regards Sridhar
Import Notes
Reply to msg id not found: 39A40422.E7D6F795@candata.com
Tried to create a table...
create table global (direct_key char(2));
Got ..
ERROR: parser: parse error at or near "global"
A quick peruse of the docs does not show global as a reserved word in
the CREATE TABLE syntax. Could someone explain this to me.
--
Dave Smith
Candata Systems Ltd.
(416) 493-9020
dave@candata.com
On page 12 of the User's Guide, it states that "global" is a reserved word
which can be used as a column label, but not as an identifier. I guess
this would include a table name as an identifier.
John McKown
On Wed, 23 Aug 2000, Dave Smith wrote:
Show quoted text
Tried to create a table...
create table global (direct_key char(2));
Got ..
ERROR: parser: parse error at or near "global"A quick peruse of the docs does not show global as a reserved word in
the CREATE TABLE syntax. Could someone explain this to me.