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

Поиск
Список
Период
Сортировка
От Yuri Levinsky
Тема PgAmin3, Anonymous code block can't be executed by pressing "Execute PG script" button.
Дата
Msg-id C9278837BA426D4DBDF8996DB8902326073CF9@Cobra.celltick.com
обсуждение исходный текст
Ответы Re: PgAmin3, Anonymous code block can't be executed by pressing "Execute PG script" button.  (Guillaume Lelarge <guillaume@lelarge.info>)
Список 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 по дате отправления:

Предыдущее
От: Yuri Levinsky
Дата:
Сообщение: FW: PgAmin3, Anonymous code block can't be executed by pressing "Execute PG script" button.
Следующее
От: bobJobS
Дата:
Сообщение: PGAdmin Crashes when a column is dropped from a table