From: | Abbas <abbas(dot)dba(at)gmail(dot)com> |
---|---|
To: | Gaurav K Srivastav <gauravgkp(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Trigger get dissabled |
Date: | 2010-06-14 17:41:02 |
Message-ID: | AANLkTilODnym7haTliqEIYMCyeMuoopTwsBBKzhgoWvk@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian von Bidder | 2010-06-14 18:33:00 | thoughts about constraint trigger |
Previous Message | John R Pierce | 2010-06-14 16:54:35 | Re: Unable to (re) start PostgreSQL 8.4.4/WinXP |