Dmitry Koterov dmitry at koterov.ru
Wed Aug 29 08:21:16 PDT 2007
Hello.

I feed the followind DDL SQL code to slonik:

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
-- Execute all schema changes.
SET statement_timeout TO 0;

/*
select count(distinct person_id)
from
    person
    join dictionary on dic_category_id=3D11
    left join person_settings on ps_person_id=3Dperson_id and ps_did=3Ddic_=
id
where
    ps_person_id is null
-- only 9000!
*/

CREATE SEQUENCE "public"."obj_setting_os_id_seq"
    INCREMENT 1  MINVALUE 1
    MAXVALUE 9223372036854775807  START 1
    CACHE 1;
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

But I see that ALL DDL code below the comment is removed, not only the
comment:

DDL Statement 0: (0,99) [
                    -- Execute all schema changes.
                    SET statement_timeout TO 0;]
Submit DDL Event to subscribers...
DDL on origin - PGRES_TUPLES_OK

Seems slonik & others parser parses SQL code incorrectly - skips everything
after a multi-line comment.
Please fix this in a new version...
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20070829/=
feefc67d/attachment.htm


More information about the Slony1-general mailing list