NotificationsYou must be signed in to change notification settings
Fork28
Star153

Commit1428229

committed

Merge commit '0d6531b812078490ef6702b83a1fdd72704c51bf' into PGPROEE9_6

2 parents0565d47 +0d6531b commit1428229Copy full SHA for 1428229

File tree

1 file changed

-7

lines changed

contrib/pgpro_scheduler
- pgpro_scheduler--1.0.sql

1 file changed

-7

lines changed

`‎contrib/pgpro_scheduler/pgpro_scheduler--1.0.sql‎`

Lines changed: 8 additions & 7 deletions

Original file line number	Diff line number	Diff line change
`@@ -121,6 +121,7 @@ BEGIN`
`121`	`121`	`IF NOT is_superuser THEN`
`122`	`122`	`RAISE EXCEPTION'access denied';`
`123`	`123`	`END IF;`
	`124`	`+RETURN TRUE;`
`124`	`125`	`END`
`125`	`126`	`$BODY$ LANGUAGE plpgsql;`
`126`	`127`
`@@ -718,7 +719,7 @@ $BODY$`
`718`	`719`	`DECLARE`
`719`	`720`	`cntinteger;`
`720`	`721`	`BEGIN`
`721`		`-SELECTonlySuperUser();`
	`722`	`+PERFORMschedule.onlySuperUser();`
`722`	`723`
`723`	`724`	`WITH aAS (DELETEFROMschedule.log RETURNING1)`
`724`	`725`	`SELECTcount(*) INTO cntFROM a;`
`@@ -751,7 +752,7 @@ DECLARE`
`751`	`752`	`iischedule.cron;`
`752`	`753`	`ooschedule.cron_rec;`
`753`	`754`	`BEGIN`
`754`		`-SELECTonlySuperUser();`
	`755`	`+PERFORMschedule.onlySuperUser();`
`755`	`756`
`756`	`757`	`FOR iiINSELECT*FROMschedule.cron LOOP`
`757`	`758`	`oo :=schedule._make_cron_rec(ii);`
`@@ -786,7 +787,7 @@ DECLARE`
`786`	`787`	`ooschedule.cron_rec;`
`787`	`788`	`BEGIN`
`788`	`789`	`IF usename<>session_user THEN`
`789`		`-SELECTonlySuperUser();`
	`790`	`+PERFORMschedule.onlySuperUser();`
`790`	`791`	`END IF;`
`791`	`792`
`792`	`793`	`FOR iiINSELECT*FROMschedule.cronWHERE owner= usename LOOP`
`@@ -822,7 +823,7 @@ DECLARE`
`822`	`823`	`ooschedule.cron_rec;`
`823`	`824`	`BEGIN`
`824`	`825`	`IF usename<>session_user THEN`
`825`		`-SELECTonlySuperUser();`
	`826`	`+PERFORMschedule.onlySuperUser();`
`826`	`827`	`END IF;`
`827`	`828`
`828`	`829`	`FOR iiINSELECT*FROMschedule.cronWHERE executor= usename LOOP`
`@@ -875,7 +876,7 @@ DECLARE`
`875`	`876`	`ii record;`
`876`	`877`	`ooschedule.cron_job;`
`877`	`878`	`BEGIN`
`878`		`-SELECTonlySuperUser();`
	`879`	`+PERFORMschedule.onlySuperUser();`
`879`	`880`	`FOR iiINSELECT*FROMschedule.atas at,schedule.cronas cronWHEREcron.id=at.cronANDat.active LOOP`
`880`	`881`	`oo.cron=ii.id;`
`881`	`882`	`oo.node=ii.node;`
`@@ -911,7 +912,7 @@ DECLARE`
`911`	`912`	`ooschedule.cron_job;`
`912`	`913`	`BEGIN`
`913`	`914`	`IF usename<>session_user THEN`
`914`		`-SELECTonlySuperUser();`
	`915`	`+PERFORMschedule.onlySuperUser();`
`915`	`916`	`END IF;`
`916`	`917`
`917`	`918`	`FOR iiINSELECT*FROMschedule.atas at,schedule.cronas cronWHEREcron.executor= usenameANDcron.id=at.cronANDat.active LOOP`
`@@ -968,7 +969,7 @@ DECLARE`
`968`	`969`	`sql_cmdtext;`
`969`	`970`	`BEGIN`
`970`	`971`	`IF usename<>session_user THEN`
`971`		`-SELECTonlySuperUser();`
	`972`	`+PERFORMschedule.onlySuperUser();`
`972`	`973`	`END IF;`
`973`	`974`
`974`	`975`	`IF usename='___all___' THEN`

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!

Commit1428229

File tree

1 file changed

1 file changed

`‎contrib/pgpro_scheduler/pgpro_scheduler--1.0.sql‎`

0 commit comments