bug: pg_dump use strange tag for trigger

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: bug: pg_dump use strange tag for trigger
Date: 2022-11-06 05:41:14
Message-ID: CAFj8pRA7_HotbwyRwTwMUy5fBkB80X4Ap=Hx6x1pTVuCveh+9w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

When I played with regression tests for pg_restore, I tested -T filtering
triggers too. I had problems with restoring triggers. I found that the name
for trigger uses the pattern "tablename triggername" (not just (and
correct) triggername).

I propose to generate tag just like trigger name

proposed patch attached

regards

Pavel

Attachment Content-Type Size
pg_dump-fix-trigger-tag.patch text/x-patch 557 bytes

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message houzj.fnst@fujitsu.com 2022-11-06 06:40:30 RE: Perform streaming logical transactions by background workers and parallel apply
Previous Message Tom Lane 2022-11-06 05:12:10 Re: explain analyze rows=%.0f