Re: Trigger get dissabled

Hi,

 

I am using  postgre SQL 8.3 on centos,

 

My case is Suppose  I a databse ABC (In this database I have few enabled trigger) and I am making  abc.tar as a dump file using pg_dump utility.

Now I am restoring abc.tar using pg_restore on another machine .

 

Up to now every thing is fine but the trigger get dissabled.

 

Can you please let me know that how can I again enable these triggers in my database schema?

 

Or Is there any way to not make trigger dissable while pg_dump or pg_restore?

 

Or is there any query to enable all the dissabled triggers in a database schema?

 

Please let me know I will be highly obliged.

 

--
Thanks & Regards
Gaurav K Srivastav