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
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 ? |