Calling now(), or current_timestamp within a transaction always returns the same value (the time the transaction started I think). Here’s a workaround that I’m using:

BEGIN;

SELECT timeofday()::timestamptz;

COMMIT;

This entry was posted on Sunday, November 18th, 2007 at 9:17 am and is filed under SQL, Code. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.