ALTER TRIGGER Before / After?

From: Josh Trutwin <josh(at)trutwins(dot)homeip(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: ALTER TRIGGER Before / After?
Date: 2007-10-29 21:23:46
Message-ID: 20071029162346.4f75516f@sinkhole.intrcomm.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Postgresql 8.1 I am guessing there isn't a convenient way to alter
a trigger to change its before/after behavior? I wrote one of my
first triggers using an AFTER and now I release I needed to
do BEFORE. It's used on a couple tables so I was hoping to avoid
dropping it and re-creating it but if that is my only option, so be
it.

Josh

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joseph S 2007-10-29 21:40:14 Re: DST problem on pg 8.2.5
Previous Message kamiseq 2007-10-29 21:23:23 Re: function and passing the table name to be used with SQL stmnt