On Mon, 2013-09-16 at 12:59 +0000, Yuri Levinsky wrote: > Dear support, > Affected version: any version. > Distribution type: any type. > Detected on OS: Win 7 > > Anonymous code block can't be executed by pressing "Execute PG script" > button, getting the following error: [ERROR ] 1.0: syntax error, > unexpected character. > > Reproduce: > > DO $$ > BEGIN > insert into tctplugagents values (7, 1, 'aaa', 'aaaa'); > EXCEPTION WHEN unique_violation THEN > -- do nothing > END$$;--EOS > > It will be successfully executed by "execute query" button pressing. >
pgscript was written previous to the inclusion of the DO statement in PostgreSQL. Since then, there's been not much work on the pgScript tool. -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
