Re: pg_dump 7.4 bug

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 majordomo(at)postgresql(dot)org
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073