DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:reply-to:to:subject:mime-version:content-type:content-transfer-encoding;
	b=JVaozk7VaZSDYK1sCK9AVQlyLxpOCkdp2oo7kMAVRJnvQiOyoUY8zwdZsC8GXJxES2+ZOJuDvxHJW5kH4FGpNVqT1WRxjW8ANOLIIkNG4TQSBnkxAi46XHd5wGoH++/2r8B5Z1X+iBs6NHfN6Z8/kHoaTz8btq+OROtFv6Hrwr4=
Message-ID: <f9870c010412091219495dbb8e@mail.gmail.com>
Date: Thu, 9 Dec 2004 15:19:56 -0500
From: Alex Beamish <talexb@gmail.com>
Reply-To: Alex Beamish <talexb@gmail.com>
To: pgsql-sql@postgresql.org
Subject: parse error at or near "(" -- Huh???
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit

Hi,

I'm getting a frustrating error

  ERROR:  parser: parse error at or near "(" at character 201

in a CREATE TABLE statement from an SQL script that I'm running from
within a Perl script. When I run the same script from the command
line, either as a regular user or as root, it works fine.

The SQL is
---------------------------------------------------------
CREATE SEQUENCE "users_id"
	START 1 INCREMENT 1 MAXVALUE 2147483647 MINVALUE 1 CACHE 1;

CREATE TABLE "users" (
	"u_id" integer DEFAULT nextval('users_id'::text) NOT NULL,
	"u_name" text NOT NULL,
	"u_password" text NOT NULL,
	"u_console_flag" integer DEFAULT 0,
	Constraint "users_pkey" Primary Key ("u_id")
);
---------------------------------------------------------

The 'console_flag' field was recently added and is close-ish to the
point that I think the parser is failing. And speaking of that, how I
am to interpret 'character 201' -- should I collapse the SQL into it's
minimal state (least number spaces) and go from that?

Thanks.

Alex

ps Tried to join the list using 
http://webmail.postgresql.org/mj/mj_wwwusr?domain=postgresql.org&func=lists-long-full&extra=pgsql-sql
but got a server timeout. :(