Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit80353f3

Browse files
committed
Adjust pg_sleep_for/pg_sleep_until to use clock_timestamp.
Otherwise, pg_sleep_until does the wrong thing in a multi-statementtransaction.Julien Rouhaud
1 parent65a193e commit80353f3

File tree

2 files changed

+3
-3
lines changed

2 files changed

+3
-3
lines changed

‎src/include/catalog/catversion.h

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -53,6 +53,6 @@
5353
*/
5454

5555
/*yyyymmddN */
56-
#defineCATALOG_VERSION_NO201401311
56+
#defineCATALOG_VERSION_NO201402031
5757

5858
#endif

‎src/include/catalog/pg_proc.h

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -3034,9 +3034,9 @@ DATA(insert OID = 2625 ( pg_ls_dirPGNSP PGUID 12 1 1000 0 0 f f f f t t v 1 0
30343034
DESCR("list all files in a directory");
30353035
DATA(insertOID=2626 (pg_sleepPGNSPPGUID121000fffftfv102278"701"_null__null__null__null_pg_sleep_null__null__null_ ));
30363036
DESCR("sleep for the specified time in seconds");
3037-
DATA(insertOID=3935 (pg_sleep_forPGNSPPGUID141000fffftfv102278"1186"_null__null__null__null_"select pg_catalog.pg_sleep(extract(epoch from pg_catalog.now() operator(pg_catalog.+) $1) operator(pg_catalog.-) extract(epoch from pg_catalog.now()))"_null__null__null_ ));
3037+
DATA(insertOID=3935 (pg_sleep_forPGNSPPGUID141000fffftfv102278"1186"_null__null__null__null_"select pg_catalog.pg_sleep(extract(epoch from pg_catalog.clock_timestamp() operator(pg_catalog.+) $1) operator(pg_catalog.-) extract(epoch from pg_catalog.clock_timestamp()))"_null__null__null_ ));
30383038
DESCR("sleep for the specified interval");
3039-
DATA(insertOID=3936 (pg_sleep_untilPGNSPPGUID141000fffftfv102278"1184"_null__null__null__null_"select pg_catalog.pg_sleep(extract(epoch from $1) operator(pg_catalog.-) extract(epoch from pg_catalog.now()))"_null__null__null_ ));
3039+
DATA(insertOID=3936 (pg_sleep_untilPGNSPPGUID141000fffftfv102278"1184"_null__null__null__null_"select pg_catalog.pg_sleep(extract(epoch from $1) operator(pg_catalog.-) extract(epoch from pg_catalog.clock_timestamp()))"_null__null__null_ ));
30403040
DESCR("sleep until the specified time");
30413041

30423042
DATA(insertOID=2971 (textPGNSPPGUID121000fffftfi1025"16"_null__null__null__null_booltext_null__null__null_ ));

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp