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

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