Satoshi Nagayasu wrote: > How about enable/disable triggers? > > >From TODO: > > Allow triggers to be disabled. > > http://momjian.postgresql.org/cgi-bin/pgtodo?trigger > > I think this is good for COPY performance improvement. > > Now I have user functions to enable/disable triggers, not DDL. > It modifies system tables. > But I can rewrite this as a DDL. (ALTER TABLE?)
Yea, it is a TODO item, and should be pretty straight-forward to code, so sure, go ahead. It has to be something that is super-user-only. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
