Re: PgAmin3, Anonymous code block can't be executed by pressing "Execute PG script" button.

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