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 [EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
