Re: Question on pg_cron

Поиск
Список
Период
Сортировка
От Ron Johnson
Тема Re: Question on pg_cron
Дата
Msg-id CANzqJaD8iuULuUOUj9LXoGKBHAL1miSPsQ8jEV9UUYf3EDAaqw@mail.gmail.com
обсуждение исходный текст
Ответ на Question on pg_cron  (yudhi s <learnerdatabase99@gmail.com>)
Ответы Re: Question on pg_cron
Список pgsql-general
On Sat, Jun 8, 2024 at 5:31 AM yudhi s <learnerdatabase99@gmail.com> wrote:
Hello All,

We have around 10 different partition tables for which the partition maintenance is done using pg_partman extension. These tables have foreign key dependency between them.  We just called partman.run_maintanance_proc() through pg_cron without any parameters and it was working fine. So we can see only one entry in the cron.job table. And it runs daily once.

It was all working fine and we were seeing the historical partition being dropped and new partitions being created without any issue. But suddenly we started seeing, its getting failed with error "ERROR: can not drop schema1.tab1_part_p2023_12_01 because other objects depend on it"
 
Have you changed version lately of PG, pg_cron or pg_partman?  Or maybe what pg_cron or pg_partman depends on?

В списке pgsql-general по дате отправления:

Предыдущее
От: Sushrut Shivaswamy
Дата:
Сообщение: Columnar Format Export in Postgres
Следующее
От: yudhi s
Дата:
Сообщение: Re: Question on pg_cron