Turning off triggers ?

From: Glen Eustace <geustace(at)godzone(dot)net(dot)nz>
To: pgsql-general(at)postgresql(dot)org
Subject: Turning off triggers ?
Date: 2002-11-25 09:23:43
Message-ID: 1038216223.30555.240.camel@agree-6
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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).

I could delete then add them again but I am hoping these is an easier
way.
--

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Glen and Rosanne Eustace,
GodZone Internet Services, a division of AGRE Enterprises Ltd.,
P.O. Box 8020, Palmerston North, New Zealand 5301
Ph/Fax: +64 6 357 8168, Mob: +64 21 424 015

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Darko Prenosil 2002-11-25 09:43:25 Location of language .mo files or 'Zašto postgres ne govori Hrvatski' ???
Previous Message Hilmar Lapp 2002-11-25 08:23:22 Re: transaction aborted, queries ignored