From d1403fd7268ccf96ab6e7d04506ea1b1802c7eb2 Mon Sep 17 00:00:00 2001 From: alecpl <alec@alec.pl> Date: Fri, 02 May 2008 03:35:00 -0400 Subject: [PATCH] - fixed #1485032 and updated MDB2 package+drivers --- program/lib/MDB2/Driver/Reverse/pgsql.php | 11 +++++++---- 1 files changed, 7 insertions(+), 4 deletions(-) diff --git a/program/lib/MDB2/Driver/Reverse/pgsql.php b/program/lib/MDB2/Driver/Reverse/pgsql.php index 930eea9..7d5c9f1 100644 --- a/program/lib/MDB2/Driver/Reverse/pgsql.php +++ b/program/lib/MDB2/Driver/Reverse/pgsql.php @@ -2,7 +2,7 @@ // +----------------------------------------------------------------------+ // | PHP versions 4 and 5 | // +----------------------------------------------------------------------+ -// | Copyright (c) 1998-2007 Manuel Lemos, Tomas V.V.Cox, | +// | Copyright (c) 1998-2008 Manuel Lemos, Tomas V.V.Cox, | // | Stig. S. Bakken, Lukas Smith | // | All rights reserved. | // +----------------------------------------------------------------------+ @@ -43,7 +43,7 @@ // | Lorenzo Alberton <l.alberton@quipo.it> | // +----------------------------------------------------------------------+ // -// $Id: pgsql.php,v 1.68 2007/11/25 13:38:29 quipo Exp $ +// $Id: pgsql.php,v 1.70 2008/03/13 20:38:09 quipo Exp $ require_once 'MDB2/Driver/Reverse/Common.php'; @@ -358,7 +358,7 @@ $query = 'SELECT a.attname FROM pg_constraint c LEFT JOIN pg_class t ON c.confrelid = t.oid - LEFT JOIN pg_attribute a ON a.attrelid = t.oid AND a.attnum = ANY(c.conkey) + LEFT JOIN pg_attribute a ON a.attrelid = t.oid AND a.attnum = ANY(c.confkey) WHERE c.conname = %s AND t.relname = ' . $db->quote($definition['references']['table'], 'text'); $constraint_name_mdb2 = $db->getIndexName($constraint_name); @@ -424,7 +424,10 @@ WHEN 24 THEN 'UPDATE, DELETE' WHEN 12 THEN 'INSERT, DELETE' END AS trigger_event, - trg.tgenabled AS trigger_enabled, + CASE trg.tgenabled + WHEN 'O' THEN 't' + ELSE trg.tgenabled + END AS trigger_enabled, obj_description(trg.oid, 'pg_trigger') AS trigger_comment FROM pg_trigger trg, pg_class tbl, -- Gitblit v1.9.1