Ann Harrison wrote:

> >  execute statement 'alter trigger MyTrigger inactive';
> >  ...
> >  execute statement 'alter trigger MyTrigger active';
> >
> > You need EXECUTE STATEMENT to circumvent the no-DDL rule in PSQL.
> >
>
> Paul's answer is technically correct, but practically disastrous. Setting
> a trigger to be inactive is a system-wide event and will stop other transactions
> on other connections from logging their changes.

You're completely right.


Cheers,
Paul Vinkenoog