OK. ---------------------------------------------------------------------------
Christopher Kings-Lynne wrote: > Only if you commit my pg_dump patch that's in the queue. > > Chris > > Bruce Momjian wrote: > > > Is this fixed in 7.5? > > > > --------------------------------------------------------------------------- > > > > Christopher Kings-Lynne wrote: > > > >>If you do this sequence of events, you get a failure to restore: > >> > >>1. As superuser, do this: > >> > >>test2=# CREATE FUNCTION plpgsql_call_handler () RETURNS language_handler > >>test2-# AS '$libdir/plpgsql.so', 'plpgsql_call_handler' > >>test2-# LANGUAGE c; > >>CREATE FUNCTION > >> > >>2. Drop privs. > >> > >>test2=# alter user chriskl with nocreateuser; > >> > >>So, now we're a regular joe user. > >> > >>3. pg_dump now gives this: > >> > >>SET SESSION AUTHORIZATION 'chriskl'; > >> > >>SET search_path = public, pg_catalog; > >> > >>-- > >>-- TOC entry 37 (OID 853309) > >>-- Name: plpgsql_call_handler(); Type: FUNC PROCEDURAL LANGUAGE; Schema: > >>public; Owner: chriskl > >>-- > >> > >>CREATE FUNCTION plpgsql_call_handler() RETURNS language_handler > >> AS '$libdir/plpgsql.so', 'plpgsql_call_handler' > >> LANGUAGE c; > >> > >>4. Now, trying to restore this as the joe user gives: > >> > >>test2=> CREATE FUNCTION plpgsql_call_handler() RETURNS language_handler > >>test2-> AS '$libdir/plpgsql.so', 'plpgsql_call_handler' > >>test2-> LANGUAGE c; > >>ERROR: permission denied for language c > >> > >>This caused me pain in the 7.4 upgrade I just performed... > >> > >>Chris > >> > >>---------------------------(end of broadcast)--------------------------- > >>TIP 4: Don't 'kill -9' the postmaster > >> > > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] > -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
