[ppa-help] [Help] ERROR: column "tgisconstraint&qu...

[SourceForge.net <no...@so...>]

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