BUG #8672: pg_sleep function doesn't work as expected

Поиск
Список
Период
Сортировка
От christophe.nicolas@9online.fr
Тема BUG #8672: pg_sleep function doesn't work as expected
Дата
Msg-id E1VpwDn-00049v-Bi@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #8672: pg_sleep function doesn't work as expected  (Pavel Stehule <pavel.stehule@gmail.com>)
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      8672
Logged by:          M CHRISTOPHE NICOLAS
Email address:      christophe.nicolas@9online.fr
PostgreSQL version: 9.2.2
Operating system:   Windows Seven
Description:

A simple example :


Create Table tst_sleep(instime timestamp);


Do '
Begin
  Insert Into tst_sleep values(Now());
  Perform pg_sleep(5);
  Insert Into tst_sleep values(Now());
End;
'


Select * From tst_sleep;
2013-12-09 09:23:54.012
2013-12-09 09:23:54.012




=> The Do execution last 5 secondes (ok), but the 2 rows are inserted as
same time.

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

Предыдущее
От: "Wang, Zhenyu"
Дата:
Сообщение: [Bug] Can not create 64bit ODBC DSN
Следующее
От: petr@petrovich.kiev.ua
Дата:
Сообщение: BUG #8673: Could not open file "pg_multixact/members/xxxx" on slave during hot_standby