{
case 1:
//DROP the rule that prohibits updates (change of spec).
- //$local_sql = "DROP RULE log_update";
- //$dbms->query($local_sql); //DISABLED FOR NEW ROLE LOG-tABLE ???
+ $local_sql = "DROP RULE log_update ON log";
+ $dbms->query($local_sql); //DISABLED FOR NEW ROLE LOG-tABLE ???
case 2:
//In the log table processed should be false by default
$local_sql .= " VALUES ('filesystem', 'Ifree', 'Number of i-nodes available', 'DYNAMIC', 1000, 1000000, 't')";
$dbms->query($local_sql);
-//These columns have to be removed when a new version of PGSQL has become mainstream that supportsa DROP COLUMN
/*
TODO:
GRANT UPDATE ON action_user_actionstepid_seq TO GROUP ops, GROUP admin;
*/
+//These columns have to be removed when a new version of PGSQL has become mainstream that supportsa DROP COLUMN
/*
$local_sql = "ALTER TABLE log DROP COLUMN recognized";