Trigger Refresh Error - PGAdmin

From: "Hart, Rob (FWP)" <RHart2(at)mt(dot)gov>
To: "pgadmin-support(at)postgresql(dot)org" <pgadmin-support(at)postgresql(dot)org>
Subject: Trigger Refresh Error - PGAdmin
Date: 2012-08-24 20:04:10
Message-ID: 3C162509E55735458234C882A95671FE62E686@DOAISD5202.state.mt.ads
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Hello,
I'm not sure whether this is a PGAdmin bug or otherwise but I was able to replicate on different servers, though I haven't tested it in other versions of pgadmin.

PG Admin v1.14.3
"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"
SLES 11 SP2

To create error:
Right click on trigger object and select refresh.

[cid:image001(dot)png(at)01CD8200(dot)2BCB0A30]

Error details taken from log:

pgdev pgAdmin III - BrowserERROR: syntax error at or near "AND" at character 527
pgdev pgAdmin III - BrowserSTATEMENT: SELECT t.oid, t.xmin, t.*, relname, CASE WHEN r
elkind = 'r' THEN TRUE ELSE FALSE END AS parentistable, nspname, des.description, l.lanname, p.prosrc,
substring(pg_get_triggerdef(t.oid), 'WHEN (.*) EXECUTE PROCEDURE') AS whenclause
FROM pg_trigger t
JOIN pg_class cl ON cl.oid=tgrelid
JOIN pg_namespace na ON na.oid=relnamespace
LEFT OUTER JOIN pg_description des ON des.objoid=t.oid
LEFT OUTER JOIN pg_proc p ON p.oid=t.tgfoid
LEFT OUTER JOIN pg_language l ON l.oid=p.prolang
WHERE NOT tgisinternal AND

AND t.tgname='ces_contact_audit' AND cl.oid=17731::oid AND cl.relnamespace=17441::oid::oid
ORDER BY tgname

Please let me know if you require any further details.
Kind Regards,
Robert Hart

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Guillaume Lelarge 2012-08-25 12:52:52 Re: Query history
Previous Message Guillaume Lelarge 2012-08-24 16:50:46 Re: regarding opening of pgAdmin III