Re: a trigger question - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: a trigger question
Date
Msg-id Pine.LNX.4.44.0206061607500.2224-100000@cm-lcon-46-187.cm.vtr.net
Whole thread Raw
In response to Re: a trigger question  ("Gregory Wood" <gregw@com-stock.com>)
List pgsql-general
El Jun 6, Gregory Wood escribio:

> Sounds like you did a CREATE FUNCTION, then a CREATE TRIGGER, then needed to
> DROP and reCREATE your function. The trigger is still looking for the old
> function, try DROP TRIGGER and CREATE TRIGGER again to make sure it points
> to the current version.

Also remember that you can just CREATE OR REPLACE the function so that
you don't have to drop and recreate the trigger afterwards.

--
Alvaro Herrera (<alvherre[a]atentus.com>)
"Pido que me den el Nobel por razones humanitarias" (Nicanor Parra)


pgsql-general by date:

Previous
From: Neil Conway
Date:
Subject: Re: how to remove columns from a table
Next
From: "Tyler Mitchell"
Date:
Subject: Demo versions