Skip site navigation (1) Skip section navigation (2)

odd alter_generic regression failures

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: odd alter_generic regression failures
Date: 2012-10-08 13:25:41
Message-ID: 5072D455.7010109@dunslane.net (view raw or flat)
Thread:
Lists: pgsql-hackers

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


Responses

pgsql-hackers by date

Next:From: Dimitri FontaineDate: 2012-10-08 13:30:05
Subject: Re: Deparsing DDL command strings
Previous:From: Merlin MoncureDate: 2012-10-08 13:20:18
Subject: Re: Regarding identifying a foreign scan

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group