On Mon, Jun 14, 2010 at 3:52 PM, Gaurav K Srivastav <gaurav...@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 >
