Re: upgrade failure from 9.5 to head - Mailing list pgsql-hackers

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.