Re: Call for port reports

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