A trigger in an extension

From: Olleg Samoylov <splarv(at)ya(dot)ru>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: A trigger in an extension
Date: 2025-02-20 19:23:18
Message-ID: 40129c90-138c-4331-a3d6-c04158cb91e0@ya.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi all.

Server version is 16.6.

I have the extension pgpro_scheduler. In the exception there are two
tables and the trigger on one of them that write to the other. I was
surprised but when I load dump created by pg_dump this trigger is
created in the pre-data stage (automatically by create extension) early
and thus has wrong behavior when uploaded data in the data stage (lead
to duplication of primary key).

I do workaround by creating superuser with
session_replication_role=replica. But what was wrong? Is this bug inside
pg_dump or pg_restore or extension pgpro_scheduler? Or something other?
--
Olleg

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2025-02-20 19:30:10 Re: A trigger in an extension
Previous Message Dietrich, Benjamin 2025-02-20 15:00:35 May data be corrupted after an interrupted, but afterwards sucessfully replayed recovery?