Horton

Re: BUG #15310: pg_upgrade dissociates event triggers from extensions

Michael Paquier <michael@paquier.xyz>

View thread View on postgr.es
From: Michael Paquier <michael@paquier.xyz>
To: Haribabu Kommi <kommi.haribabu@gmail.com>
Cc: nickbarnes01@gmail.com, pgsql-bugs@lists.postgresql.org
Date: 2018-08-07T11:29:10Z
Lists: pgsql-bugs 
On Tue, Aug 07, 2018 at 07:40:24PM +1000, Haribabu Kommi wrote:
> Yes, I feel it is a bug. During the dump of the event trigger during
> upgrade, it lost
> the dependency on extension.

That sounds like a bug to me.  Could you add more tests to
src/test/modules/test_pg_dump with an event trigger part of an extension
with a binary upgrade test?  It would be good to check as well 
if the other object types you have mentioned correctly work or not.
--
Michael

Commits

  1. Don't record FDW user mappings as members of extensions.

  2. Fix pg_upgrade to handle event triggers in extensions correctly.