Re: normal user dump gives error because of plpgsql - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: normal user dump gives error because of plpgsql
Date
Msg-id 20050310124412.GC23460@svana.org
Whole thread Raw
In response to normal user dump gives error because of plpgsql  (Janning Vygen <vygen@gmx.de>)
Responses Re: normal user dump gives error because of plpgsql
List pgsql-general
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@svana.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.

Attachment

pgsql-general by date:

Previous
From: Miroslav Šulc
Date:
Subject: Re: Locale problem
Next
From: "Sim Zacks"
Date:
Subject: Re: pl sql to check if table of table_name exists