Thread: odd alter_generic regression failures

We seem to have an intermittent failure on the alter_generic tests that 
look like this:
      SET SESSION AUTHORIZATION regtest_alter_user1;      CREATE FUNCTION alt_func1(int) RETURNS int LANGUAGE sql
AS 'SELECT $1 + 1';   + ERROR:  permission denied for language sql      CREATE FUNCTION alt_func2(int) RETURNS int
LANGUAGEsql        AS 'SELECT $1 - 1';   + ERROR:  permission denied for language sql      CREATE AGGREGATE alt_agg1 (
     sfunc1 = int4pl, basetype = int4, stype1 = int4, initcond = 0      );
 

This has been seen on at least two buildfarm members: chough (Windows/MSVC) and smilodon (NetBSD/gcc). The fact that
it'sintermittent is rather worrying and puzzling.
 

cheers

andrew

Andrew Dunstan <andrew@dunslane.net> writes:
> We seem to have an intermittent failure on the alter_generic tests that 
> look like this:

>        SET SESSION AUTHORIZATION regtest_alter_user1;
>        CREATE FUNCTION alt_func1(int) RETURNS int LANGUAGE sql
>          AS 'SELECT $1 + 1';
>     + ERROR:  permission denied for language sql
>        CREATE FUNCTION alt_func2(int) RETURNS int LANGUAGE sql
>          AS 'SELECT $1 - 1';
>     + ERROR:  permission denied for language sql
>        CREATE AGGREGATE alt_agg1 (
>          sfunc1 = int4pl, basetype = int4, stype1 = int4, initcond = 0
>        );

I poked around and realized that the reason for this is that it's run in
parallel with the "privileges" test, which does:

REVOKE ALL PRIVILEGES ON LANGUAGE sql FROM PUBLIC;
... various stuff ...
GRANT ALL PRIVILEGES ON LANGUAGE sql TO PUBLIC;

So the current placement of that test is no better than the original :-(
I'll put it someplace else.
        regards, tom lane