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

=?ISO-8859-1?Q?Josu=E9_Maldonado?= <josue@lamundial.hn> writes:
> Tom Lane wrote:
>> Hard to believe.  Could you give us a complete example, not a partial
>> one?

> This is the code in the trigger function:

I tried this with a table created like so:

regression=# create table tinv (
regression(# f1 int,
regression(# f2 text,
regression(# f3 float8,
regression(# duser name);
CREATE TABLE

and I get output like

regression=# update tinv set f1=55;
NOTICE:  Inicio:
NOTICE:  ID tiene f2)
NOTICE:  OLD tiene z
NOTICE:  NEW tiene z
NOTICE:  ID tiene f3)
NOTICE:  OLD tiene 3.4
NOTICE:  NEW tiene 3.4
NOTICE:  ID tiene duser)
NOTICE:  OLD tiene d
NOTICE:  NEW tiene d
NOTICE:  ID tiene f1)
NOTICE:  OLD tiene 1
NOTICE:  NEW tiene 55
UPDATE 1
regression=#

which is okay as far as I can see...

            regards, tom lane