Hello,
Dropping a trigger is permitted if the user is the owner of the table
for which the trigger is defined.
In a plpgsql function, used by different users, I need to disable some
triggers for a short period of time. With the pgsql user login, I can
succesfully drop and create the trigger again (after locking the tables
for which I drop triggers), but unfortunately this not possible with a
different user login, since they are not the owner of the table.
What could I do in this situation?
Thanks
Philippe Lang
