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

Commit0d6531b

Browse files
author
Vladimir Ershov
committed
fix super user call
1 parent05f245a commit0d6531b

File tree

1 file changed

+8
-7
lines changed

1 file changed

+8
-7
lines changed

‎pgpro_scheduler--1.0.sql

Lines changed: 8 additions & 7 deletions
Original file line numberDiff line numberDiff line change
@@ -121,6 +121,7 @@ BEGIN
121121
IF NOT is_superuser THEN
122122
RAISE EXCEPTION'access denied';
123123
END IF;
124+
RETURN TRUE;
124125
END
125126
$BODY$ LANGUAGE plpgsql;
126127

@@ -718,7 +719,7 @@ $BODY$
718719
DECLARE
719720
cntinteger;
720721
BEGIN
721-
SELECTonlySuperUser();
722+
PERFORMschedule.onlySuperUser();
722723

723724
WITH aAS (DELETEFROMschedule.log RETURNING1)
724725
SELECTcount(*) INTO cntFROM a;
@@ -751,7 +752,7 @@ DECLARE
751752
iischedule.cron;
752753
ooschedule.cron_rec;
753754
BEGIN
754-
SELECTonlySuperUser();
755+
PERFORMschedule.onlySuperUser();
755756

756757
FOR iiINSELECT*FROMschedule.cron LOOP
757758
oo :=schedule._make_cron_rec(ii);
@@ -786,7 +787,7 @@ DECLARE
786787
ooschedule.cron_rec;
787788
BEGIN
788789
IF usename<>session_user THEN
789-
SELECTonlySuperUser();
790+
PERFORMschedule.onlySuperUser();
790791
END IF;
791792

792793
FOR iiINSELECT*FROMschedule.cronWHERE owner= usename LOOP
@@ -822,7 +823,7 @@ DECLARE
822823
ooschedule.cron_rec;
823824
BEGIN
824825
IF usename<>session_user THEN
825-
SELECTonlySuperUser();
826+
PERFORMschedule.onlySuperUser();
826827
END IF;
827828

828829
FOR iiINSELECT*FROMschedule.cronWHERE executor= usename LOOP
@@ -875,7 +876,7 @@ DECLARE
875876
ii record;
876877
ooschedule.cron_job;
877878
BEGIN
878-
SELECTonlySuperUser();
879+
PERFORMschedule.onlySuperUser();
879880
FOR iiINSELECT*FROMschedule.atas at,schedule.cronas cronWHEREcron.id=at.cronANDat.active LOOP
880881
oo.cron=ii.id;
881882
oo.node=ii.node;
@@ -911,7 +912,7 @@ DECLARE
911912
ooschedule.cron_job;
912913
BEGIN
913914
IF usename<>session_user THEN
914-
SELECTonlySuperUser();
915+
PERFORMschedule.onlySuperUser();
915916
END IF;
916917

917918
FOR iiINSELECT*FROMschedule.atas at,schedule.cronas cronWHEREcron.executor= usenameANDcron.id=at.cronANDat.active LOOP
@@ -968,7 +969,7 @@ DECLARE
968969
sql_cmdtext;
969970
BEGIN
970971
IF usename<>session_user THEN
971-
SELECTonlySuperUser();
972+
PERFORMschedule.onlySuperUser();
972973
END IF;
973974

974975
IF usename='___all___' THEN

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp