On July 6, 2007 05:46 am, Dmitry Koterov wrote:
> Hello.
>
> I feed the following syntax-correct query to slonik:
>
> CREATE RULE "position_get_last_id_on_insert" AS ON INSERT TO
> "public"."position"
> DO (SELECT currval('position_position_id_seq'::regclass) AS id;);
>
> And in pg logs I see:
>
> 2007-07-06 12:39:08 GMT 87.250.244.99(34424)ERROR:  syntax error at end of
> input at character 149
> 2007-07-06 12:39:08 GMT 87.250.244.99(34424)STATEMENT:
>         CREATE RULE "position_get_last_id_on_insert" AS ON INSERT TO
> "public"."position"
>         DO (SELECT currval('position_position_id_seq'::regclass) AS id;
>
> Seems slonik treats intermediate ";" as a queries delimiter and splits
> queries by it.
> Possibly slonik should care about correct brackets nesting?

How did you feed the to slonik?  slonik does not speek SQL, but is a interface 
to the internal slon functions.



-- 
Darcy Buskermolen
Command Prompt, Inc.
+1.503.667.4564 X 102
http://www.commandprompt.com/
PostgreSQL solutions since 1997