I think PG does fixed time within a tran. check the output of the following sql
begin; select now() ; select pg_sleep(10); select now() ; commit; select now() ; select pg_sleep(10); select now() ; ~ On Tue, Apr 12, 2016 at 6:50 AM, Alex Ignatov <a.igna...@postgrespro.ru> wrote: > Hello! > Is there any method to freeze localtimestamp and other time function value. > Say after freezing on some value sequential calls to these functions give > you the same value over and over again. > This is useful primarily for testing. > > In oracle there is alter system set fixed_date command. Have Postgres this > functionality? > > -- > Alex Ignatov > Postgres Professional: http://www.postgrespro.com > The Russian Postgres Company > > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
