Thread: Trigger get dissabled

Trigger get dissabled

From

Gaurav K Srivastav

Date:

14 June 2010, 16:46:10

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

Re: Trigger get dissabled

From

Abbas

Date:

14 June 2010, 17:41:31

On Mon, Jun 14, 2010 at 3:52 PM, Gaurav K Srivastav <gauravgkp@gmail.com> wrote:

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.

Are you sure that you didn't use --disable-triggers option while taking the pg_dump?

---
Abbas.

--
Thanks & Regards
Gaurav K Srivastav