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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-hackers by date

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