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?
_______________________________________________
Slony1-general mailing list
[email protected]
http://lists.slony.info/mailman/listinfo/slony1-general
