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

From darren@crystalballinc.com
Subject Re: TCL trigger doesn't work after deleting a column
Date
Msg-id Pine.LNX.4.44.0309031706090.16213-100000@thread.crystalballinc.com
Whole thread Raw
In response to TCL trigger doesn't work after deleting a column  (Josué Maldonado <josue@lamundial.hn>)
List pgsql-general
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

HTH
Darren


On Wed, 3 Sep 2003, Josué Maldonado wrote:

> Hello list,
>
> The TCL trigger that uses NEW and OLD arrays failed after after I
> removed a unused column, now I got this error:
>
> pltcl: Cache lookup for attribute '........pg.dropped.24........' type 0
> failed
>
> I already did a vacuum, but the error remain. Any idea how to fix/avoid
> that?
>
> Thanks in advance
>
>

--
Darren Ferguson


pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: absolute value fro timestamps
Next
From: "Dann Corbit"
Date:
Subject: Re: delivering database stand-alone