Re: TCL trigger doesn't work after deleting a column

From: Josué Maldonado <josue(at)lamundial(dot)hn>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: TCL trigger doesn't work after deleting a column
Date: 2003-09-03 21:29:41
Message-ID: 3F565D45.70202@lamundial.hn
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi Darren,

darren(at)crystalballinc(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jan Wieck 2003-09-03 21:30:39 Re: pg_autovacuum
Previous Message Bo Lorentsen 2003-09-03 21:28:33 Re: Using oids