Christopher, is this problem fixed now?
--------------------------------------------------------------------------- Christopher Kings-Lynne wrote: > Hi all, > > Just tested latest CVS on my freebsd/alpha. Only one test failed, and > that's privileges related... > > *** ./expected/privileges.out Thu Mar 7 09:53:51 2002 > --- ./results/privileges.out Fri Mar 8 11:03:36 2002 > *************** > *** 201,218 **** > CREATE FUNCTION testfunc1(int) RETURNS int AS 'select 2 * $1;' LANGUAGE > sql; > CREATE FUNCTION testfunc2(int) RETURNS int AS 'select 3 * $1;' LANGUAGE > sql; > GRANT EXECUTE ON FUNCTION testfunc1(int), testfunc2(int) TO regressuser2; > GRANT USAGE ON FUNCTION testfunc1(int) TO regressuser3; -- semantic error > ! ERROR: invalid privilege type USAGE for function object > GRANT ALL PRIVILEGES ON FUNCTION testfunc1(int) TO regressuser4; > GRANT ALL PRIVILEGES ON FUNCTION testfunc_nosuch(int) TO regressuser4; > ! ERROR: Function 'testfunc_nosuch(int4)' does not exist > SET SESSION AUTHORIZATION regressuser2; > SELECT testfunc1(5), testfunc2(5); -- ok > ! testfunc1 | testfunc2 > ! -----------+----------- > ! 10 | 15 > ! (1 row) > ! > CREATE FUNCTION testfunc3(int) RETURNS int AS 'select 2 * $1;' LANGUAGE > sql; -- fail > ERROR: permission denied > SET SESSION AUTHORIZATION regressuser3; > --- 201,216 ---- > CREATE FUNCTION testfunc1(int) RETURNS int AS 'select 2 * $1;' LANGUAGE > sql; > CREATE FUNCTION testfunc2(int) RETURNS int AS 'select 3 * $1;' LANGUAGE > sql; > GRANT EXECUTE ON FUNCTION testfunc1(int), testfunc2(int) TO regressuser2; > + ERROR: bogus GrantStmt.objtype 458 > GRANT USAGE ON FUNCTION testfunc1(int) TO regressuser3; -- semantic error > ! ERROR: bogus GrantStmt.objtype 458 > GRANT ALL PRIVILEGES ON FUNCTION testfunc1(int) TO regressuser4; > + ERROR: bogus GrantStmt.objtype 458 > GRANT ALL PRIVILEGES ON FUNCTION testfunc_nosuch(int) TO regressuser4; > ! ERROR: bogus GrantStmt.objtype 458 > SET SESSION AUTHORIZATION regressuser2; > SELECT testfunc1(5), testfunc2(5); -- ok > ! ERROR: permission denied > CREATE FUNCTION testfunc3(int) RETURNS int AS 'select 2 * $1;' LANGUAGE > sql; -- fail > ERROR: permission denied > SET SESSION AUTHORIZATION regressuser3; > *************** > *** 220,230 **** > ERROR: permission denied > SET SESSION AUTHORIZATION regressuser4; > SELECT testfunc1(5); -- ok > ! testfunc1 > ! ----------- > ! 10 > ! (1 row) > ! > DROP FUNCTION testfunc1(int); -- fail > ERROR: RemoveFunction: function 'testfunc1': permission denied > \c - > --- 218,224 ---- > ERROR: permission denied > SET SESSION AUTHORIZATION regressuser4; > SELECT testfunc1(5); -- ok > ! ERROR: permission denied > DROP FUNCTION testfunc1(int); -- fail > ERROR: RemoveFunction: function 'testfunc1': permission denied > \c - > > ====================================================================== [ Attachment, skipping... ] [ Attachment, skipping... ] > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED]) -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
