The following forum message was posted by jasmine629 at http://sourceforge.net/projects/phppgadmin/forums/forum/115884/topic/6150737:
Hello,
I'm running phpPgAdmin 5.0.4 with PostgreSQL 9.2.1 on Mac 10.7.5, and have received
the error below when attempting to create a trigger. I had no problems creating
the function. I installed phpPgAdmin using the PostgreSQL Add-ons feature of
its install dmg.
[code]SQL error:
ERROR: column "tgisconstraint" does not exist
LINE 9: AND (NOT tgisconstraint OR NOT EXISTS
^
In statement:
SELECT
t.tgname, pg_catalog.pg_get_triggerdef(t.oid) AS tgdef,
CASE WHEN t.tgenabled = 'D' THEN FALSE ELSE TRUE END AS tgenabled, p.oid
AS prooid,
p.proname || ' (' || pg_catalog.oidvectortypes(p.proargtypes) || ')' AS
proproto,
ns.nspname AS pronamespace
FROM pg_catalog.pg_trigger t, pg_catalog.pg_proc p, pg_catalog.pg_namespace
ns
WHERE t.tgrelid = (SELECT oid FROM pg_catalog.pg_class WHERE
relname='Sessions'
AND relnamespace=(SELECT oid FROM pg_catalog.pg_namespace WHERE
nspname='public'))
AND (NOT tgisconstraint OR NOT EXISTS
(SELECT 1 FROM pg_catalog.pg_depend d JOIN pg_catalog.pg_constraint c
ON (d.refclassid = c.tableoid AND d.refobjid = c.oid)
WHERE d.classid = t.tableoid AND d.objid = t.oid AND d.deptype = 'i' AND
c.contype = 'f'))
AND p.oid=t.tgfoid
AND p.pronamespace = ns.oid[/code]
Any assistance would be greatly appreciated.
Thank you,
Jasmine
|
