Anomalies with the now() function

Поиск
Список
Период
Сортировка
От Byrne Kevin-kbyrne01
Тема Anomalies with the now() function
Дата
Msg-id 496E31A690F7D311B93C0008C789494C122463FC@zei02exm01.cork.cig.mot.com
обсуждение исходный текст
Ответы Re: Anomalies with the now() function  (Michael Fuhr <mike@fuhr.org>)
Re: Anomalies with the now() function  (Andreas Seltenreich <andreas+pg@gate450.dyndns.org>)
Re: Anomalies with the now() function  (David Roussel <diroussel@xsmail.com>)
Список pgsql-general
I have a trigger set up on a db - when a row is added to a certain table (say Table A) in my db the trigger calls a
functionand then the function enters another line in a related table (say Table B). Here's the problem, the first
additionto Table A may show the time of the addition as, for example 19:01:53. This is correct. The second addition,
triggeredby the first additon, shows a time of say 19:01:10! The addition of the row to Table B uses the now() function
todetermine the time the new row is added to the table. This should in theory match the time (to within a few
millisecondsat least) the first row was added, since the trigger is immediate. However, I am seeing major time
differences?How reliable is now() - has anyone seen anything similar ? 

Reagards,
Kevin Byrne


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

Предыдущее
От: jbduffy@tiscali.co.uk
Дата:
Сообщение: plperlu Question
Следующее
От: Harald Armin Massa
Дата:
Сообщение: shorter way to get new value of serial?