From: | Adam Witney <awitney(at)sghms(dot)ac(dot)uk> |
---|---|
To: | Glen Eustace <geustace(at)godzone(dot)net(dot)nz> |
Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Turning off triggers ? |
Date: | 2002-11-25 16:26:24 |
Message-ID: | BA07FFB0.C2F2%a.witney@sghms.ac.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Never tried this myself but there is an entry in the cookbook pages that, on
the face of it seems to do what you are asking...
http://www.brasileiro.net:8080/postgres/cookbook/view-one-recipe.adp?recipe_
id=5925
> On 25 Nov 2002, Glen Eustace wrote:
>
>> Is there a way that all the triggers associated with a table can be
>> turned off ? I would like to be able to bulk load a table ( I have to
>> use inserts not copy ) and I don't want the triggers to fire. Once
>> loaded I want to turn them back on again. This process will be repeated
>> quite often ( during the development phase).
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
From | Date | Subject | |
---|---|---|---|
Next Message | Jean-Luc Lachance | 2002-11-25 16:41:51 | Re: Turning off triggers ? |
Previous Message | Marc G. Fournier | 2002-11-25 16:19:23 | RC2 Packaged in Preparation for a Wednesday Release ... |