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  (Jan Wieck <JanWieck@Yahoo.com>)
Список 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 по дате отправления:

Предыдущее
От: Ron Johnson
Дата:
Сообщение: Re: What is the good equivalent for ENUM ?
Следующее
От: Ashley Cambrell
Дата:
Сообщение: Re: [HACKERS] Using oids