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

Commit2bcb2b5

Browse files
committed
Fix migration script
1 parent910c3ec commit2bcb2b5

File tree

2 files changed

+19
-4
lines changed

2 files changed

+19
-4
lines changed

‎pg_wait_sampling--1.0--1.1.sql

Lines changed: 18 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -5,21 +5,21 @@ DROP FUNCTION pg_wait_sampling_get_current (
55
OUT pid int4,
66
OUT event_typetext,
77
OUT eventtext
8-
);
8+
) CASCADE;
99

1010
DROPFUNCTION pg_wait_sampling_get_history (
1111
OUT pid int4,
1212
OUT tstimestamptz,
1313
OUT event_typetext,
1414
OUT eventtext
15-
);
15+
) CASCADE;
1616

1717
DROPFUNCTION pg_wait_sampling_get_profile (
1818
OUT pid int4,
1919
OUT event_typetext,
2020
OUT eventtext,
2121
OUT countbigint
22-
);
22+
) CASCADE;
2323

2424
CREATEFUNCTIONpg_wait_sampling_get_current (
2525
pid int4,
@@ -32,6 +32,11 @@ RETURNS SETOF record
3232
AS'MODULE_PATHNAME'
3333
LANGUAGE C VOLATILE CALLEDONNULL INPUT;
3434

35+
CREATEVIEWpg_wait_sampling_currentAS
36+
SELECT*FROM pg_wait_sampling_get_current(NULL::integer);
37+
38+
GRANTSELECTON pg_wait_sampling_current TO PUBLIC;
39+
3540
CREATEFUNCTIONpg_wait_sampling_get_history (
3641
OUT pid int4,
3742
OUT tstimestamptz,
@@ -43,6 +48,11 @@ RETURNS SETOF record
4348
AS'MODULE_PATHNAME'
4449
LANGUAGE C VOLATILE STRICT;
4550

51+
CREATEVIEWpg_wait_sampling_historyAS
52+
SELECT*FROM pg_wait_sampling_get_history();
53+
54+
GRANTSELECTON pg_wait_sampling_history TO PUBLIC;
55+
4656
CREATEFUNCTIONpg_wait_sampling_get_profile (
4757
OUT pid int4,
4858
OUT event_typetext,
@@ -53,3 +63,8 @@ CREATE FUNCTION pg_wait_sampling_get_profile (
5363
RETURNS SETOF record
5464
AS'MODULE_PATHNAME'
5565
LANGUAGE C VOLATILE STRICT;
66+
67+
CREATEVIEWpg_wait_sampling_profileAS
68+
SELECT*FROM pg_wait_sampling_get_profile();
69+
70+
GRANTSELECTON pg_wait_sampling_profile TO PUBLIC;

‎pg_wait_sampling.c

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -770,7 +770,7 @@ pg_wait_sampling_get_history(PG_FUNCTION_ARGS)
770770
*/
771771
staticPlannedStmt*
772772
pgws_planner_hook(Query*parse,intcursorOptions,
773-
ParamListInfoboundParams)
773+
ParamListInfoboundParams)
774774
{
775775
if (MyProc)
776776
{

0 commit comments

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