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