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.0309032023270.17978-100000@thread.crystalballinc.com
Whole thread Raw
In response to Re: TCL trigger doesn't work after deleting a column  (Josué Maldonado <josue@lamundial.hn>)
Responses Re: TCL trigger doesn't work after deleting a column
List pgsql-general
Not sure exactly why but put [array names NEW] in an elog and put [array
names OLD] in an elog then make sure they are all there.

If they are all there then the foreach will definately work

Also the ID tiene $id) <--- if not in original code good otherwise should
not be there

Darren

On Wed, 3 Sep 2003, 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
>

--
Darren Ferguson


pgsql-general by date:

Previous
From: Ron Johnson
Date:
Subject: Re: What is the good equivalent for ENUM ?
Next
From: Ashley Cambrell
Date:
Subject: Re: [HACKERS] Using oids