Re: normal user dump gives error because of plpgsql

On Thu, Mar 10, 2005 at 01:31:26PM +0100, Janning Vygen wrote:
> Hi,
>
> i have a normal user with rights to create a db. template1 contains language
> plpgsql. the user wants to
> - dump his db
> - drop his db
> - create it again
> - and use the dump file to fill it.
>
> it gives errors because of CREATE LANGUAGE statements inside the dump.

I don't beleive there is. But it's not really needed, you get and error
and the restore continues. The only thing different is that you don't
get a message, the result is the same.
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.