Trigger Refresh Error - PGAdmin
От | Hart, Rob (FWP) |
---|---|
Тема | Trigger Refresh Error - PGAdmin |
Дата | |
Msg-id | 3C162509E55735458234C882A95671FE62E686@DOAISD5202.state.mt.ads обсуждение исходный текст |
Ответы |
Re: Trigger Refresh Error - PGAdmin
|
Список | pgadmin-support |
<div class="WordSection1"><p class="MsoNormal">Hello,<p class="MsoNormal">I’m not sure whether this is a PGAdmin bug or otherwisebut I was able to replicate on different servers, though I haven’t tested it in other versions of pgadmin.<p class="MsoNormal"> <pclass="MsoNormal"> <p class="MsoNormal">PG Admin v1.14.3<p class="MsoNormal">"PostgreSQL 9.1.4 on x86_64-unknown-linux-gnu,compiled by gcc (SUSE Linux) 4.3.4 [gcc-4_3-branch revision 152973], 64-bit"<p class="MsoNormal">SLES11 SP2<p class="MsoNormal"> <p class="MsoNormal">To create error:<p class="MsoNormal">Right click ontrigger object and select refresh.<p class="MsoNormal"> <p class="MsoNormal"><img height="283" id="Picture_x0020_2" src="cid:image001.png@01CD8200.2BCB0A30"width="534" /><p class="MsoNormal"> <p class="MsoNormal"><b>Error details taken fromlog:</b><p class="MsoNormal"> <p class="MsoNormal">pgdev pgAdmin III - BrowserERROR: syntax error at or near "AND" atcharacter 527<p class="MsoNormal">pgdev pgAdmin III - BrowserSTATEMENT: SELECT t.oid, t.xmin, t.*, relname, CASE WHENr<p class="MsoNormal">elkind = 'r' THEN TRUE ELSE FALSE END AS parentistable, nspname, des.description, l.lanname,p.prosrc,<p class="MsoNormal"> substring(pg_get_triggerdef(t.oid), 'WHEN (.*) EXECUTE PROCEDURE') AS whenclause<pclass="MsoNormal"> FROM pg_trigger t<p class="MsoNormal"> JOIN pg_class cl ON cl.oid=tgrelid<pclass="MsoNormal"> JOIN pg_namespace na ON na.oid=relnamespace<p class="MsoNormal"> LEFTOUTER JOIN pg_description des ON des.objoid=t.oid<p class="MsoNormal"> LEFT OUTER JOIN pg_proc p ONp.oid=t.tgfoid<p class="MsoNormal"> LEFT OUTER JOIN pg_language l ON l.oid=p.prolang<p class="MsoNormal"> WHERE NOT tgisinternal AND<p class="MsoNormal"> <p class="MsoNormal"> AND t.tgname='ces_contact_audit'AND cl.oid=17731::oid AND cl.relnamespace=17441::oid::oid<p class="MsoNormal"> ORDERBY tgname<p class="MsoNormal"> <p class="MsoNormal">Please let me know if you require any further details.<p class="MsoNormal">KindRegards,<p class="MsoNormal">Robert Hart<p class="MsoNormal"> </div>
В списке pgadmin-support по дате отправления: