| public createTrigger ( $tgname, $table, $tgproc, $tgtime, $tgevent, $tgfrequency, $tgargs ) | ||
| $tgname | The name of the trigger to create | |
| $table | The name of the table | |
| $tgproc | The function to execute | |
| $tgtime | BEFORE or AFTER | |
| $tgevent | Event | |
| $tgargs | The function arguments | |
function createTrigger($tgname, $table, $tgproc, $tgtime, $tgevent, $tgfrequency, $tgargs)
{
$f_schema = $this->_schema;
$this->fieldClean($f_schema);
$this->fieldClean($tgname);
$this->fieldClean($table);
$this->fieldClean($tgproc);
/* No Statement Level Triggers in PostgreSQL (by now) */
$sql = "CREATE TRIGGER \"{$tgname}\" {$tgtime}\n\t\t\t\t{$tgevent} ON \"{$f_schema}\".\"{$table}\"\n\t\t\t\tFOR EACH {$tgfrequency} EXECUTE PROCEDURE \"{$tgproc}\"({$tgargs})";
return $this->execute($sql);
}