Re: bug: pg_dump use strange tag for trigger - Mailing list pgsql-hackers

From Tom Lane
Subject Re: bug: pg_dump use strange tag for trigger
Date
Msg-id 3011146.1667746334@sss.pgh.pa.us
Whole thread Raw
In response to bug: pg_dump use strange tag for trigger  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: bug: pg_dump use strange tag for trigger
List pgsql-hackers
Pavel Stehule <pavel.stehule@gmail.com> writes:
> 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

Trigger names by themselves aren't even a little bit unique, so that
doesn't seem like a great idea to me.  There's backwards compatibility
to worry about, too.  Maybe we need a documentation adjustment, instead?

            regards, tom lane



pgsql-hackers by date:

Previous
From: Álvaro Herrera
Date:
Subject: Re: Small TAP improvements
Next
From: gkokolatos@pm.me
Date:
Subject: Re: Add LZ4 compression in pg_dump