| 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: | Whole Thread | Raw Message | 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 ... |