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
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 |