Freezing localtimestamp and other time function on some value

Поиск
Список
Период
Сортировка
От Alex Ignatov
Тема Freezing localtimestamp and other time function on some value
Дата
Msg-id 570CD2E3.4030400@postgrespro.ru
обсуждение исходный текст
Ответы Re: Freezing localtimestamp and other time function on some value  (Petr Korobeinikov <pkorobeinikov@gmail.com>)
Re: Freezing localtimestamp and other time function on some value  (Pavel Stehule <pavel.stehule@gmail.com>)
Re: Freezing localtimestamp and other time function on some value  (Rakesh Kumar <rakeshkumar464a3@gmail.com>)
Список pgsql-general
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



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

Предыдущее
От: Alexander Pyhalov
Дата:
Сообщение: pgpool-II: cannot use serializable mode in a hot standby
Следующее
От: Petr Korobeinikov
Дата:
Сообщение: Re: Freezing localtimestamp and other time function on some value