Is "OFFSET" a reserved word? - Mailing list pgsql-general

From Mark Dalphin
Subject Is "OFFSET" a reserved word?
Date
Msg-id 37A1E3A6.9456F415@amgen.com
Whole thread Raw
Responses Re: [GENERAL] Is "OFFSET" a reserved word?
List pgsql-general
Hi,

My old DB schema which worked up thru Postgresql ver 6.4.2 has been broken in
ver 6.5.1 (running on an SGI).

CREATE TABLE Seq (
    .....
    Offset int not null,
    ....
);

now fails with a parse error at 'offset'. I don't see this word listed in the
reserved words page. When I change the word to SeqOffset, the schema works fine.

Mark

--
Mark Dalphin                          email: mdalphin@amgen.com
Mail Stop: 29-2-A                     phone: +1-805-447-4951 (work)
One Amgen Center Drive                       +1-805-375-0680 (home)
Thousand Oaks, CA 91320                 fax: +1-805-499-9955 (work)




pgsql-general by date:

Previous
From: The Hermit Hacker
Date:
Subject: Non-Code Contributing ...
Next
From: Bruce Momjian
Date:
Subject: Re: [GENERAL] Is "OFFSET" a reserved word?