parse error at or near "(" -- Huh???
От | Alex Beamish |
---|---|
Тема | parse error at or near "(" -- Huh??? |
Дата | |
Msg-id | f9870c010412091219495dbb8e@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: parse error at or near "(" -- Huh???
Re: parse error at or near "(" -- Huh??? |
Список | pgsql-sql |
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" textNOT 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. :(
В списке pgsql-sql по дате отправления: