Re: Disabling Trigger

"Prasad dev" <esteem3300(at)hotmail(dot)com> writes:
> Currently i am using 8.0.3 , what i mean by it doesn't work is, when i set
> the tgenabled to FALSE for that particular trigger it still fires the
> trigger unless there is something more to it which i doesn't know.

If you start a fresh session, you'll probably find that it doesn't fire
the trigger anymore.

The trick is to get existing sessions to notice that you changed the
pg_trigger row; they don't watch for that. What they do watch for is
updates of pg_class, which is why a dummy update of the table's pg_class
row might help.

regards, tom lane