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