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

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.

Sincerely yours,

Yuri Levinsky, DBA

Celltick Technologies Ltd., 32 Maskit St., Herzliya 46733, Israel

Mobile: +972 54 6107703, Office: +972 9 9710239; Fax: +972 9 9710222