Re: [PERFORM] now() gives same time within the session

2010-07-12 Thread Atul.Goel
Sure thanks a lot. Regards, Atul Goel -Original Message- From: pgsql-performance-ow...@postgresql.org [mailto:pgsql-performance-ow...@postgresql.org] On Behalf Of A. Kretschmer Sent: 12 July 2010 12:15 To: pgsql-performance@postgresql.org Subject: Re: [PERFORM] now() gives same time with

[PERFORM] now() gives same time within the session

2010-07-12 Thread Atul.Goel
Hi, I need to log the start and end time of the procedures in a table. But the start and end time are same. This is how I recreated the issue. create table test_time (time timestamp); delete from test_time; insert into test_time select now(); SELECT pg_sleep(10); insert into test_time select no