Re: [HACKERS] odd alter_generic regression failures

2012-10-15 Thread Tom Lane 
Andrew Dunstan and...@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


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

[HACKERS] odd alter_generic regression failures

2012-10-08 Thread Andrew Dunstan 



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
  );

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

cheers

andrew


--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers