Re: upgrade failure from 9.5 to head

Hi,

On 2015-07-29 10:16:10 -0400, Andrew Dunstan wrote:
>
> My cross-version upgrade testing tool just threw up this failure, upgrading
> from 9.5 to head:
>
> CREATE ROLE "dummy_seclabel_user1";
> CREATE ROLE
> ALTER ROLE "dummy_seclabel_user1" WITH NOSUPERUSER INHERIT
> CREATEROLE NOCREATEDB LOGIN NOREPLICATION NOBYPASSRLS;
> ALTER ROLE
> SECURITY LABEL FOR "dummy" ON ROLE "dummy_seclabel_user1" IS
> 'classified';
> psql:pg_upgrade_dump_globals.sql:25: ERROR: security label provider
> "dummy" is not loaded

Ick! So the dummy_seclabel test more or less only works by accident if I
see that correctly. The .so is only loaded because the CREATE EXTENSION
in the test triggers a CREATE FUNCTION dummy_seclabel_dummy() ... LANG
C.

That's pretty damn ugly.