| 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: | Whole Thread | Raw Message | 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 ? |