Re: Trigger get dissabled

On Mon, Jun 14, 2010 at 3:52 PM, Gaurav K Srivastav <gauravgkp(at)gmail(dot)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
>