PgAmin3, Anonymous code block can't be executed by pressing "Execute PG script" button. - Mailing list pgadmin-support

From Yuri Levinsky
Subject PgAmin3, Anonymous code block can't be executed by pressing "Execute PG script" button.
Date
Msg-id C9278837BA426D4DBDF8996DB8902326073CF9@Cobra.celltick.com
Whole thread Raw
Responses Re: PgAmin3, Anonymous code block can't be executed by pressing "Execute PG script" button.
List pgadmin-support
<div class="WordSection1"><p class="MsoNormal"><b><i><span style="color:black"></span></i></b><span
style="color:black"> Dearsupport,</span><p class="MsoNormal"><span
style="font-family:"Georgia","serif";color:black">Affectedversion: any version.</span><p class="MsoNormal"><span
style="font-family:"Georgia","serif";color:black">Distributiontype: any type.</span><p class="MsoNormal"><span
style="font-family:"Georgia","serif";color:black">Detectedon OS: Win 7</span><p class="MsoNormal"><span
style="font-family:"Georgia","serif";color:black"> </span><pclass="MsoNormal"><span
style="font-family:"Georgia","serif";color:black">Anonymouscode block can't be executed by pressing "Execute PG script"
button,getting the following error: [ERROR    ] 1.0: syntax error, unexpected character.</span><p
class="MsoNormal"><spanstyle="font-family:"Georgia","serif";color:black"> </span><p class="MsoNormal"><span
style="font-family:"Georgia","serif";color:black">Reproduce:</span><pclass="MsoNormal"><span
style="font-family:"Georgia","serif";color:black"> </span><pclass="MsoNormal"><span
style="font-family:"Georgia","serif";color:black">DO$$</span><p class="MsoNormal"><span
style="font-family:"Georgia","serif";color:black">BEGIN</span><pclass="MsoNormal"><span
style="font-family:"Georgia","serif";color:black"> insert into tctplugagents values (7, 1, 'aaa', 'aaaa');  </span><p
class="MsoNormal"><spanstyle="font-family:"Georgia","serif";color:black">  EXCEPTION WHEN unique_violation
THEN</span><pclass="MsoNormal"><span style="font-family:"Georgia","serif";color:black">            -- do
nothing</span><pclass="MsoNormal"><span style="font-family:"Georgia","serif";color:black">END$$;--EOS</span><p
class="MsoNormal"><spanstyle="font-family:"Georgia","serif";color:black"> </span><p class="MsoNormal"><span
style="font-family:"Georgia","serif";color:black">Itwill be successfully executed by "execute query" button pressing.
</span><pclass="MsoNormal"><span style="font-family:"Georgia","serif";color:black"> </span><p
class="MsoNormal"><i><spanstyle="font-size:10.0pt;font-family:"Arial","sans-serif";color:#111111">Sincerely
yours</span></i><spanstyle="color:black">,</span><p class="MsoNormal"><span style="color:black"> </span><p
class="MsoNormal"><spanstyle="color:black"><img alt="Description: Celltick logo_highres" height="53"
id="Picture_x0020_1"src="cid:image002.jpg@01CEB2F3.9312C140" width="143" /></span><p class="MsoNormal"><span
style="font-size:8.0pt;font-family:"Arial","sans-serif";color:black">YuriLevinsky, DBA</span><span
style="font-size:10.0pt;font-family:"Arial","sans-serif";color:black"></span><pclass="MsoNormal"><span
style="font-size:8.0pt;font-family:"Arial","sans-serif";color:black">CelltickTechnologies Ltd., 32 Maskit St., Herzliya
46733,Israel</span><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:black"></span><p
class="MsoNormal"><spanstyle="font-size:8.0pt;font-family:"Arial","sans-serif";color:black">Mobile: +972 54 6107703,
Office:+972 9 9710239; Fax: +972 9 9710222</span><span
style="font-size:10.0pt;font-family:"Arial","sans-serif";color:black"></span><pclass="MsoNormal"> </div> 

pgadmin-support by date:

Previous
From: Yuri Levinsky
Date:
Subject: FW: PgAmin3, Anonymous code block can't be executed by pressing "Execute PG script" button.
Next
From: bobJobS
Date:
Subject: PGAdmin Crashes when a column is dropped from a table