Sample Header Ad - 728x90

pg_cron Installed by Superuser Not Showing Records to Developers

0 votes
0 answers
28 views
We have pg_cron installed on our PostgreSQL 13 database. The cron schema and job table are visible to all users. When the admin user runs SELECT * FROM cron.job, it returns rows as expected. However, when any developer runs the same query, it returns 0 rows, despite the query executing successfully. Why might developers be seeing an empty result set, and how can we resolve this issue to allow developers to see the job records?
Asked by Muhammad sami (1 rep)
Aug 6, 2024, 11:08 AM