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
Re: Anomalies with the now() function Re: Anomalies with the now() function |
Список | 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 по дате отправления: