pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedBUG #18918: cron.schedule_in_database ERROR: must be superuser to create a job for another role
2+ messages / 2 participants
[nested] [flat]
* BUG #18918: cron.schedule_in_database ERROR: must be superuser to create a job for another role
@ 2025-05-08 15:54 PG Bug reporting form <noreply@postgresql.org>
0 siblings, 1 reply; 2+ messages in thread
From: PG Bug reporting form @ 2025-05-08 15:54 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org; +Cc: silvanlaube@hotmail.com
The following bug has been logged on the website:
Bug reference: 18918
Logged by: Silvan Laube
Email address: silvanlaube@hotmail.com
PostgreSQL version: 16.8
Operating system: whatever Azure uses
Description:
This throws an "ERROR: must be superuser to create a job for another role"
SELECT cron.schedule_in_database(
'refresh_mv',
'30 5 * * *',
'REFRESH MATERIALIZED VIEW schema.my_view;',
'my-db',
current_user, -- or specified as 'my_user'
true
);
but this will work, and schedule the job as current_user:
SELECT cron.schedule_in_database(
'refresh_mv',
'30 5 * * *',
'REFRESH MATERIALIZED VIEW schema.my_view;',
'my-db'
);
seems unintended and extremely confusing
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: BUG #18918: cron.schedule_in_database ERROR: must be superuser to create a job for another role
@ 2025-05-08 18:17 David G. Johnston <david.g.johnston@gmail.com>
parent: PG Bug reporting form <noreply@postgresql.org>
0 siblings, 0 replies; 2+ messages in thread
From: David G. Johnston @ 2025-05-08 18:17 UTC (permalink / raw)
To: silvanlaube@hotmail.com <silvanlaube@hotmail.com>; pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>
On Thursday, May 8, 2025, PG Bug reporting form <noreply@postgresql.org>
wrote:
> The following bug has been logged on the website:
>
> Bug reference: 18918
> Logged by: Silvan Laube
> Email address: silvanlaube@hotmail.com
> PostgreSQL version: 16.8
> Operating system: whatever Azure uses
> Description:
>
> This throws an "ERROR: must be superuser to create a job for another role"
> SELECT cron.schedule_in_database(
>
>
There is no function with that name in the core community PostgreSQL
distribution. You should report this wherever the people who created that
extension are expecting to see bug reports filed.
David J.
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2025-05-08 18:17 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2025-05-08 15:54 BUG #18918: cron.schedule_in_database ERROR: must be superuser to create a job for another role PG Bug reporting form <noreply@postgresql.org>
2025-05-08 18:17 ` David G. Johnston <david.g.johnston@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox