Horton

Re: Call for port reports

Peter Eisentraut <peter_e@gmx.net>

View thread View on postgr.es
From: Peter Eisentraut <peter_e@gmx.net>
To: Larry Rosenman <ler@lerctr.org>
Cc: Bruce Momjian <pgman@candle.pha.pa.us>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2003-10-25T20:29:04Z
Lists: pgsql-hackers 
Larry Rosenman writes:

> *** ./expected/privileges.out	Thu Oct  9 20:49:31 2003
> --- ./results/privileges.out	Sat Oct 25 12:04:45 2003
> ***************
> *** 247,253 ****
>   (1 row)
>
>   CREATE FUNCTION testfunc3(int) RETURNS int AS 'select 2 * $1;' LANGUAGE
> sql; -- fail
> - ERROR:  permission denied for language sql
>   SET SESSION AUTHORIZATION regressuser3;
>   SELECT testfunc1(5); -- fail
>   ERROR:  permission denied for function testfunc1
> --- 247,252 ----

That sounds extremely strange.  Can you step through the privileges.sql
file manually (psql single-step mode) and check what the contents of
pg_language, pg_shadow, current_user, and session_user are before the
misbehaving command?

-- 
Peter Eisentraut   peter_e@gmx.net