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

From: darren(at)crystalballinc(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 00:24:54
Message-ID: Pine.LNX.4.44.0309032023270.17978-100000@thread.crystalballinc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ashley Cambrell 2003-09-04 00:28:01 Re: [HACKERS] Using oids
Previous Message Ron Johnson 2003-09-03 23:57:57 Re: What is the good equivalent for ENUM ?