Postgres Pro
Downloads
Home   >   mailing lists

AW: BUG #18918: cron.schedule_in_database ERROR: must be superuser to create a job for another role - Mailing list pgsql-bugs

From Silvan Laube
Subject AW: BUG #18918: cron.schedule_in_database ERROR: must be superuser to create a job for another role
Date
Msg-id AM0PR05MB4660D71BBF5CC36BBBB809F1BF8AA@AM0PR05MB4660.eurprd05.prod.outlook.com
Whole thread Raw
In response to Re: BUG #18918: cron.schedule_in_database ERROR: must be superuser to create a job for another role  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-bugs
Tree view
Right, sorry, forgot pg_cron is an extension. Reported here: https://github.com/citusdata/pg_cron/issues/390
Von: David G. Johnston <david.g.johnston@gmail.com>
Gesendet: Donnerstag, 8. Mai 2025 20:17
An: silvanlaube@hotmail.com <silvanlaube@hotmail.com>; pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>
Betreff: Re: BUG #18918: cron.schedule_in_database ERROR: must be superuser to create a job for another role
 
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.

pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #18920: LOAD '$libdir/plugins' no longer works in 18beta1
Next
From: Shlok Kyal
Date:
Subject: Re: BUG #18897: Logical replication conflict after using pg_createsubscriber under heavy load