On Mon, Jan 28, 2013 at 10:54 AM, Craig James wrote:
> But if the drop-and-restore-trigger operation blocks all access to the
> tables, that's a problem.
>
Were the triggers in question created with "CREATE CONSTRAINT TRIGGER"? If
not, "ALTER TABLE foo DISABLE TRIGGER USER" may do what you need
On 28/01/13 18:54, Craig James wrote:
If I drop and then recreate a trigger inside of a single transaction,
how does it affect other processes trying to use the same table? Can
they just merrily go along their way using the table, or will they be
blocked by an exclusive lock?
I *think* it b
If I drop and then recreate a trigger inside of a single transaction, how
does it affect other processes trying to use the same table? Can they just
merrily go along their way using the table, or will they be blocked by an
exclusive lock?
We have a trigger that detects illegal drugs and dangerous