Is "OFFSET" a reserved word?

From: Mark Dalphin <mdalphin(at)amgen(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Is "OFFSET" a reserved word?
Date: 1999-07-30 17:40:54
Message-ID: 37A1E3A6.9456F415@amgen.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)amgen(dot)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)

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 1999-07-30 18:10:00 Re: [GENERAL] Is "OFFSET" a reserved word?
Previous Message The Hermit Hacker 1999-07-30 17:25:56 Non-Code Contributing ...