AW: BUG #18918: cron.schedule_in_database ERROR: must be superuser to create a job for another role

From: Silvan Laube <silvanlaube(at)hotmail(dot)com>
To: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: AW: BUG #18918: cron.schedule_in_database ERROR: must be superuser to create a job for another role
Date: 2025-05-09 09:52:57
Message-ID: AM0PR05MB4660D71BBF5CC36BBBB809F1BF8AA@AM0PR05MB4660.eurprd05.prod.outlook.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Right, sorry, forgot pg_cron is an extension. Reported here: https://github.com/citusdata/pg_cron/issues/390
________________________________
Von: David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>
Gesendet: Donnerstag, 8. Mai 2025 20:17
An: silvanlaube(at)hotmail(dot)com <silvanlaube(at)hotmail(dot)com>; pgsql-bugs(at)lists(dot)postgresql(dot)org <pgsql-bugs(at)lists(dot)postgresql(dot)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(at)postgresql(dot)org<mailto:noreply(at)postgresql(dot)org>> wrote:
The following bug has been logged on the website:

Bug reference: 18918
Logged by: Silvan Laube
Email address: silvanlaube(at)hotmail(dot)com<mailto:silvanlaube(at)hotmail(dot)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.

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2025-05-10 10:10:18 BUG #18921: The larger the value of max_parallel_workers_per_gather, the longer the SQL execution time.
Previous Message PG Bug reporting form 2025-05-08 19:55:51 BUG #18920: LOAD '$libdir/plugins' no longer works in 18beta1