Postgres Pro
Downloads
Home   >   mailing lists

Re: Trigger get dissabled - Mailing list pgsql-general

From Abbas
Subject Re: Trigger get dissabled
Date
Msg-id AANLkTilODnym7haTliqEIYMCyeMuoopTwsBBKzhgoWvk@mail.gmail.com
Whole thread Raw
In response to Trigger get dissabled  (Gaurav K Srivastav <gauravgkp@gmail.com>)
List pgsql-general
Tree view


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

pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: Unable to (re) start PostgreSQL 8.4.4/WinXP
Next
From: "M. Bashir Al-Noimi"
Date:
Subject: Silent installer in Windows