| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Germán Hüttemann Arza <ghuttemann(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Enable/Disable Triggers |
| Date: | 2007-01-22 16:21:35 |
| Message-ID: | 18998.1169482895@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
=?iso-8859-1?q?Germ=E1n_H=FCttemann_Arza?= <ghuttemann(at)gmail(dot)com> writes:
> Hello,
> I tried to execute ALTER TABLE emp DISABLE TRIGGER after_ins_emp on PostgreSQL
> 7.4.13 and I realised that feature isn't include yet in this version.
> How can I enable/disable a trigger in this version of PostgreSQL?
Update?
Seriously, although the tgenabled column exists in that version, I seem
to recall that it wasn't honored everywhere in the code, and there are
some caching effects to worry about too. I'm afraid you'll find that
changing it manually works only erratically, if at all.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alan Hodgson | 2007-01-22 16:24:59 | Re: triggers and TriggerData |
| Previous Message | Ron Peterson | 2007-01-22 16:21:22 | Re: CAST function for user defined type |