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

From Ian Harding
Subject Re: TCL trigger doesn't work after deleting a column
Date
Msg-id 3F56EE42.9000603@tpchd.org
Whole thread Raw
In response to Re: TCL trigger doesn't work after deleting a column  (Josué Maldonado <josue@lamundial.hn>)
List pgsql-general
Nulls.  That's the only thing I can think of.

Josué Maldonado wrote:

> Noticed that the loop does not go through all fields:
>
> foreach id [array names NEW] {
>   elog NOTICE "ID tiene $id)"
>   elog NOTICE "OLD tiene $OLD($id)"
>   elog NOTICE "NEW tiene $NEW($id)"
> }
>
> foreach id [array names OLD] {
>   elog NOTICE "ID tiene $id)"
>   elog NOTICE "OLD tiene $OLD($id)"
>   elog NOTICE "NEW tiene $NEW($id)"
> }
>
> Both cases the loop skips some fields, any idea?
>
> Thanks.
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings




pgsql-general by date:

Previous
From: "Derrick Betts"
Date:
Subject: SQL Error: pqReadData() -- read() failed: errno=0 No error
Next
From: "Matthew T. O'Connor"
Date:
Subject: Re: pg_autovacuum