Re: Problems with NEW.* in triggers

Поиск
Список
Период
Сортировка
От Jamie Lawrence
Тема Re: Problems with NEW.* in triggers
Дата
Msg-id 20031105001653.GD2879@clueinc.net
обсуждение исходный текст
Ответ на Re: Problems with NEW.* in triggers  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-sql
On Tue, 04 Nov 2003, Tom Lane wrote:

> Jamie Lawrence <postgres@jal.org> writes:
> > I don't understand why moddate isn't getting set to now() in the above.
> 
> Josh fingered the problem there --- you need a BEFORE trigger if you
> want to affect the data that will be stored.  I had missed that little
> mistake :-(

Yep. Many thanks to both of you.

-j


-- 
Jamie Lawrence                                        jal@jal.org
If built in great numbers, motels will be used for nothing but illegal
purposes.   - J. Edgar Hoover




В списке pgsql-sql по дате отправления:

Предыдущее
От: Marcus Krause
Дата:
Сообщение: No output while using PEAR DB & formatted time-string
Следующее
От: alban
Дата:
Сообщение: 7.3 : how add user when last user have lost 'createuser' option