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

From: Jan Wieck <JanWieck(at)Yahoo(dot)com>
To: Josué Maldonado <josue(at)lamundial(dot)hn>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: TCL trigger doesn't work after deleting a column
Date: 2003-09-04 19:40:11
Message-ID: 3F57951B.6020200@Yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

close the connection and reconnect to get a fresh backend that doesn't
cache anything.

Jan

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
>

--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck(at)Yahoo(dot)com #

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jan Wieck 2003-09-04 19:45:39 Re: TCL trigger doesn't work after deleting a column
Previous Message Guillaume LELARGE 2003-09-04 19:39:35 Re: French translation