"Prasad dev" <esteem3300@hotmail.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