| From: | Bob Parkinson <rwp(at)biome(dot)ac(dot)uk> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | disabling triggers? |
| Date: | 2000-07-18 15:07:45 |
| Message-ID: | Pine.OSF.4.21.0007181603140.15419-100000@omni.ac.uk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi,
I've noticed the recent query about dropping a function with a trigger.
I've got a trigger/function pair that I need to disable while I do a
manual update. Is it safe to drop the trigger, then re-create it on its
own, or should I do the trigger/function pair.
Is there a better method of temporarily disabling a trigger?
Cheers,
Bob
Bob Parkinson
rwp(at)biome(dot)ac(dot)uk
------------------------------------------------------------------
Technical Manager: Biome http://biome.ac.uk/
Greenfield Medical Library,
Queens Medical Centre,
Nottingham. 0115 9249924 x 42059
------------------------------------------------------------------
We are stardust
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2000-07-18 15:50:38 | Re: ordering of 'where' sub clauses |
| Previous Message | Alex Bolenok | 2000-07-18 15:00:42 | Re: Migrating from MS SQL server |