Sincerely yours,
![Description: Celltick logo_highres](/media/maillist_attaches/pgadmin-support/2013/09/16/C9278837BA426D4DBDF8996DB8902326073CE0@Cobra.celltick.com/image001.jpg)
Yuri Levinsky, DBA
Celltick Technologies Ltd., 32 Maskit St., Herzliya 46733, Israel
Mobile: +972 54 6107703, Office: +972 9 9710239; Fax: +972 9 9710222
From: Yuri Levinsky
Sent: Monday, September 16, 2013 3:44 PM
To: 'pgadmin-support-request@postgresql.org'
Subject: 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,
![Description: Celltick logo_highres](/media/maillist_attaches/pgadmin-support/2013/09/16/C9278837BA426D4DBDF8996DB8902326073CE0@Cobra.celltick.com/image002.jpg)
Yuri Levinsky, DBA
Celltick Technologies Ltd., 32 Maskit St., Herzliya 46733, Israel
Mobile: +972 54 6107703, Office: +972 9 9710239; Fax: +972 9 9710222