Re: TCL trigger doesn't work after deleting a column - Mailing list pgsql-general

From Josué Maldonado
Subject Re: TCL trigger doesn't work after deleting a column
Date
Msg-id 3F565D45.70202@lamundial.hn
Whole thread Raw
In response to TCL trigger doesn't work after deleting a column  (Josué Maldonado <josue@lamundial.hn>)
Responses Re: TCL trigger doesn't work after deleting a column  (Josué Maldonado <josue@lamundial.hn>)
List pgsql-general
Hi Darren,

darren@crystalballinc.com wrote:

>From what i am seeing / thinking did you drop it from the table ???
>
> I am assuming yes and therefore you should recreate the function and the
> trigger and you should be fine.
>
> Using 7.3.x use the CREATE OR REPLACE FUNCTION to replace the function so
> it will still have the same OID.
>
> Next drop the trigger and then recreate the trigger and you should be fine

Did that, and still got the same error. I'm currently preparing the
server to update to 7.3.4 I hope this could help.

Thanks



pgsql-general by date:

Previous
From: Adam Kavan
Date:
Subject: Re: Index not being used ?
Next
From: Tom Lane
Date:
Subject: Re: Using oids