Index: phpPgAdmin/db_dump.php =================================================================== RCS file: /usr/local/cvsroot/phppgadmin/phpPgAdmin/db_dump.php,v retrieving revision 1.1.1.1 diff -r1.1.1.1 db_dump.php 125a126,223 > // Output triggers > > // Some definitions > $TRIGGER_TYPE_ROW = (1 << 0); > $TRIGGER_TYPE_BEFORE = (1 << 1); > $TRIGGER_TYPE_INSERT = (1 << 2); > $TRIGGER_TYPE_DELETE = (1 << 3); > $TRIGGER_TYPE_UPDATE = (1 << 4); > > $sql_get_triggers = " > SELECT > pt.*, pp.proname, pc.relname > FROM > pg_trigger pt, pg_proc pp, pg_class pc > WHERE > pp.oid=pt.tgfoid > and pt.tgrelid=pc.oid > and relname !~ '^pg_' > "; > > $triggers = @pg_exec($link, pre_query($sql_get_triggers)); > if (!$num_triggers = @pg_numrows($triggers)) { > print "$crlf/* $strNo $strTriggers $strFound */$crlf"; > } else { > print "$crlf/* -------------------------------------------------------- $crlf"; > print " $strTriggers $crlf"; > print "-------------------------------------------------------- */ $crlf"; > > for ($i_triggers = 0; $i_triggers < $num_triggers; $i_triggers++) { > $trigger = pg_fetch_array($triggers, $i_triggers); > // Constraint or not > if ($trigger[tgisconstraint] == 't') > print "CREATE CONSTRAINT TRIGGER"; > else > print "CREATE TRIGGER"; > // Name > print " $cfgQuotes$trigger[tgname]$cfgQuotes"; > > // before/after > if ($trigger[tgtype] & $TRIGGER_TYPE_BEFORE) > print " BEFORE"; > else > print " AFTER"; > > // Insert > $findx = 0; > if ($trigger[tgtype] & $TRIGGER_TYPE_INSERT) { > print " INSERT"; > $findx++; > } > > // Delete > if ($trigger[tgtype] & $TRIGGER_TYPE_DELETE) { > if ($findx > 0) > print " OR DELETE"; > else > print " DELETE"; > $findx++; > } > > // Update > if ($trigger[tgtype] & $TRIGGER_TYPE_UPDATE) { > if ($findx > 0) > print " OR UPDATE"; > else > print " UPDATE"; > } > > // On > print " ON $cfgQuotes$trigger[relname]$cfgQuotes"; > > // Contraints, deferrable > if ($trigger[tgisconstraint] == 't') { > if ($trigger[tgdeferrable] == 'f') print " NOT"; > print " DEFERRABLE INITIALLY "; > > if ($trigger[tginitdeferred] == 't') > print "DEFERRED"; > else > print "IMMEDIATE"; > } > echo " FOR EACH ROW"; > echo " EXECUTE PROCEDURE $cfgQuotes$trigger[proname]$cfgQuotes ('"; > > // Strip of trailing delimiter > $tgargs = trim(substr($trigger[tgargs], 0, strlen($trigger[tgargs]) - 4)); > $params = explode('\000', $tgargs); > > for ($i = 0; $i < sizeof($params); $i++) { > $params[$i] = str_replace("'", "\\'", $params[$i]); > } > $params = implode("', '", $params); > echo htmlspecialchars($params), "');$crlf"; > } > } > > // Output functions > 135d232 < Index: phpPgAdmin/english.inc.php =================================================================== RCS file: /usr/local/cvsroot/phppgadmin/phpPgAdmin/english.inc.php,v retrieving revision 1.3 diff -r1.3 english.inc.php 183a184,185 > $strTrigger = "Trigger"; > $strTriggers = "Triggers";