Re: TCL trigger doesn't work after deleting a column
От | darren@crystalballinc.com |
---|---|
Тема | Re: TCL trigger doesn't work after deleting a column |
Дата | |
Msg-id | Pine.LNX.4.44.0309032023270.17978-100000@thread.crystalballinc.com обсуждение исходный текст |
Ответ на | Re: TCL trigger doesn't work after deleting a column (Josué Maldonado <josue@lamundial.hn>) |
Ответы |
Re: TCL trigger doesn't work after deleting a column
|
Список | 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 по дате отправления: