From: Alex Beamish <talexb@gmail.com>
To: pgsql-sql@postgresql.org
Subject: parse error at or near "(" -- Huh???
Date: Thu, 9 Dec 2004 15:19:56 -0500
Message-ID: <f9870c010412091219495dbb8e@mail.gmail.com> (raw)
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=...
but got a server timeout. :(
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: talexb@gmail.com
Subject: Re: parse error at or near "(" -- Huh???
In-Reply-To: <f9870c010412091219495dbb8e@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox