NotificationsYou must be signed in to change notification settings
Fork39
Star162

Commitf6a2203

committed

remove old functions for good

1 parent64efec7 commitf6a2203Copy full SHA for f6a2203

File tree

2 files changed

+33

-348

lines changed

2 files changed

+33

-348

lines changed

`‎pg_wait_sampling--1.1--1.2.sql`

Lines changed: 31 additions & 38 deletions

Original file line number	Diff line number	Diff line change
`@@ -3,28 +3,28 @@`
`3`	`3`	`-- complain if script is sourced in psql, rather than via ALTER EXTENSION`
`4`	`4`	`\echo Use"ALTER EXTENSION pg_wait_sampling UPDATE TO 1.2" to load this file. \quit`
`5`	`5`
`6`		`---DROP FUNCTION pg_wait_sampling_get_current (`
`7`		`---pid int4,`
`8`		`---OUT pid int4,`
`9`		`---OUT event_type text,`
`10`		`---OUT event text`
`11`		`---) CASCADE;`
`12`		`---`
`13`		`---DROP FUNCTION pg_wait_sampling_get_history (`
`14`		`---OUT pid int4,`
`15`		`---OUT ts timestamptz,`
`16`		`---OUT event_type text,`
`17`		`---OUT event text`
`18`		`---) CASCADE;`
`19`		`---`
`20`		`---DROP FUNCTION pg_wait_sampling_get_profile (`
`21`		`---OUT pid int4,`
`22`		`---OUT event_type text,`
`23`		`---OUT event text,`
`24`		`---OUT count bigint`
`25`		`---) CASCADE;`
	`6`	`+DROPFUNCTION pg_wait_sampling_get_current (`
	`7`	`+pid int4,`
	`8`	`+OUT pid int4,`
	`9`	`+OUT event_typetext,`
	`10`	`+OUT eventtext`
	`11`	`+) CASCADE;`
	`12`	`+`
	`13`	`+DROPFUNCTION pg_wait_sampling_get_history (`
	`14`	`+OUT pid int4,`
	`15`	`+OUT tstimestamptz,`
	`16`	`+OUT event_typetext,`
	`17`	`+OUT eventtext`
	`18`	`+) CASCADE;`
`26`	`19`
`27`		`-CREATEFUNCTIONpg_wait_sampling_get_current_extended (`
	`20`	`+DROPFUNCTION pg_wait_sampling_get_profile (`
	`21`	`+OUT pid int4,`
	`22`	`+OUT event_typetext,`
	`23`	`+OUT eventtext,`
	`24`	`+OUT countbigint`
	`25`	`+) CASCADE;`
	`26`	`+`
	`27`	`+CREATEFUNCTIONpg_wait_sampling_get_current (`
`28`	`28`	`pid int4,`
`29`	`29`	`OUT pid int4,`
`30`	`30`	`OUT event_typetext,`
`@@ -45,12 +45,12 @@ RETURNS SETOF record`
`45`	`45`	`AS'MODULE_PATHNAME'`
`46`	`46`	`LANGUAGE C VOLATILE CALLEDONNULL INPUT;`
`47`	`47`
`48`		`-CREATEVIEWpg_wait_sampling_current_extendedAS`
`49`		`-SELECT*FROMpg_wait_sampling_get_current_extended(NULL::integer);`
	`48`	`+CREATEVIEWpg_wait_sampling_currentAS`
	`49`	`+SELECT*FROMpg_wait_sampling_get_current(NULL::integer);`
`50`	`50`
`51`	`51`	`GRANTSELECTON pg_wait_sampling_current TO PUBLIC;`
`52`	`52`
`53`		`-CREATEFUNCTIONpg_wait_sampling_get_history_extended (`
	`53`	`+CREATEFUNCTIONpg_wait_sampling_get_history (`
`54`	`54`	`OUT pid int4,`
`55`	`55`	`OUT event_typetext,`
`56`	`56`	`OUT eventtext,`
`@@ -71,12 +71,12 @@ RETURNS SETOF record`
`71`	`71`	`AS'MODULE_PATHNAME'`
`72`	`72`	`LANGUAGE C VOLATILE STRICT;`
`73`	`73`
`74`		`-CREATEVIEWpg_wait_sampling_history_extendedAS`
`75`		`-SELECT*FROMpg_wait_sampling_get_history_extended();`
	`74`	`+CREATEVIEWpg_wait_sampling_historyAS`
	`75`	`+SELECT*FROMpg_wait_sampling_get_history();`
`76`	`76`
`77`		`-GRANTSELECTONpg_wait_sampling_history_extended TO PUBLIC;`
	`77`	`+GRANTSELECTONpg_wait_sampling_history TO PUBLIC;`
`78`	`78`
`79`		`-CREATEFUNCTIONpg_wait_sampling_get_profile_extended (`
	`79`	`+CREATEFUNCTIONpg_wait_sampling_get_profile (`
`80`	`80`	`OUT pid int4,`
`81`	`81`	`OUT event_typetext,`
`82`	`82`	`OUT eventtext,`
`@@ -97,10 +97,10 @@ RETURNS SETOF record`
`97`	`97`	`AS'MODULE_PATHNAME'`
`98`	`98`	`LANGUAGE C VOLATILE STRICT;`
`99`	`99`
`100`		`-CREATEVIEWpg_wait_sampling_profile_extendedAS`
`101`		`-SELECT*FROMpg_wait_sampling_get_profile_extended();`
	`100`	`+CREATEVIEWpg_wait_sampling_profileAS`
	`101`	`+SELECT*FROMpg_wait_sampling_get_profile();`
`102`	`102`
`103`		`-GRANTSELECTONpg_wait_sampling_profile_extended TO PUBLIC;`
	`103`	`+GRANTSELECTONpg_wait_sampling_profile TO PUBLIC;`
`104`	`104`
`105`	`105`	`CREATEFUNCTIONpg_wait_sampling_reset_history()`
`106`	`106`	`RETURNS void`
`@@ -109,10 +109,3 @@ LANGUAGE C VOLATILE STRICT;`
`109`	`109`
`110`	`110`	`-- Don't want this to be available to non-superusers.`
`111`	`111`	`REVOKE ALLON FUNCTION pg_wait_sampling_reset_history()FROM PUBLIC;`
`112`		`-`
`113`		`---CREATE VIEW pg_wait_sampling_profile AS`
`114`		`---SELECT pid, event_type, event, queryid, SUM(count) FROM pg_wait_sampling_profile_extended`
`115`		`---GROUP BY pid, event_type, event, queryid;`
`116`		`---`
`117`		`---GRANT SELECT ON pg_wait_sampling_profile TO PUBLIC;`
`118`		`-`

0 commit comments

Comments

(0)

Movatterモバイル変換

Navigation Menu

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

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Commitf6a2203

File tree

2 files changed

2 files changed

`‎pg_wait_sampling--1.1--1.2.sql`

0 commit comments