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