<?php if (!isset($message)) { include("header.inc.php"); } else { show_message($message); } $sql_trigger_props = " SELECT pt.*, pp.proname, pc.relname, py.typname FROM pg_trigger pt, pg_proc pp, pg_class pc, pg_type py WHERE pp.oid=pt.tgfoid and pt.tgtype=py.oid and pt.tgrelid=pc.oid and tgname = '$trigger' "; if (!$res_props = pg_exec($link, pre_query($sql_trigger_props))) { pg_die(); } else { $row = @pg_fetch_array($res_props, 0); // Construct function definition $query = "?db=$db&rel_type=function&function=" . urlencode($row[proname]); $fn = "<a href=\"func_properties.php$query\">" . $row[proname] . "</a>"; // Strip off trailing delimiter $tgargs = trim(substr($row[tgargs], 0, strlen($row[tgargs]) - 4)); $params = explode('\000', $tgargs); for ($i = 0; $i < sizeof($params); $i++) { $params[$i] = str_replace("'", "\\'", $params[$i]); } $defn = implode("', '", $params); ?> <table border=<?php echo $cfgBorder;?>> <TR> <TH><?php echo $strTrigger; ?></TH> <TH><?php echo $strRetType; ?></TH> <TH><?php echo $strEnabled; ?></TH> <TH><?php echo $strIsConstraint; ?></TH> <TH><?php echo $strConstraintName; ?></TH> <TH><?php echo $strDeferrable; ?></TH> <TH><?php echo $strInitDeferred; ?></TH> </TR> <tr bgcolor="<?php echo $cfgBgcolorOne;?>"> <td class=data><b><?php echo $row[tgname];?></b></td> <td><?php echo $row[typname]; ?></td> <td><?php echo ($row[tgenabled] == 't') ? 'Y' : 'N'; ?></td> <td><?php echo ($row[tgisconstraint] == 't') ? 'Y' : 'N'; ?></td> <td><?php echo $row[tgconstrname]; ?></td> <td><?php echo ($row[tgdeferrable] == 't') ? 'Y' : 'N'; ?></td> <td><?php echo ($row[tginitdeferred] == 't') ? 'Y' : 'N'; ?></td> <tr><th colspan=7><?php echo $strFunc;?></th></tr> <tr> <td colspan=7 bgcolor="<?php echo $cfgBgcolorTwo; ?>"><?php echo $fn, " ('", htmlspecialchars($defn), "')"; ?></td> </tr> <?php echo "</table>"; } include ("footer.inc.php"); ?>