| From: | Alvaro Herrera <alvherre(at)atentus(dot)com> |
|---|---|
| To: | Gregory Wood <gregw(at)com-stock(dot)com> |
| Cc: | pblunat <pblunat(at)ujf-grenoble(dot)fr>, PostgreSQL-General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: a trigger question |
| Date: | 2002-06-06 20:09:02 |
| Message-ID: | Pine.LNX.4.44.0206061607500.2224-100000@cm-lcon-46-187.cm.vtr.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Zhou, Lixin | 2002-06-06 20:36:25 | Re: a trigger question |
| Previous Message | Neil Conway | 2002-06-06 19:59:17 | Re: how to remove columns from a table |