Re: [GENERAL] normal user dump gives error because of plpgsql

2005-03-14 Thread Janning Vygen
Am Donnerstag, 10. März 2005 18:17 schrieb Tom Lane: > John Sidney-Woollett <[EMAIL PROTECTED]> writes: > > I'm pretty sure I had the same problem when using pg_restore. If > > pl/pgsql is installed in template1, then the restore fails. > > > > And I couldn't find any solution to this on the list e

Re: [GENERAL] normal user dump gives error because of plpgsql

2005-03-10 Thread John Sidney-Woollett
Tom Lane wrote: John Sidney-Woollett <[EMAIL PROTECTED]> writes: I'm pretty sure I had the same problem when using pg_restore. If pl/pgsql is installed in template1, then the restore fails. And I couldn't find any solution to this on the list either. You're supposed to restore into a database cl

Re: [GENERAL] normal user dump gives error because of plpgsql

2005-03-10 Thread Tom Lane
John Sidney-Woollett <[EMAIL PROTECTED]> writes: > I'm pretty sure I had the same problem when using pg_restore. If > pl/pgsql is installed in template1, then the restore fails. > And I couldn't find any solution to this on the list either. You're supposed to restore into a database cloned from

Re: [GENERAL] normal user dump gives error because of plpgsql

2005-03-10 Thread John Sidney-Woollett
I'm pretty sure I had the same problem when using pg_restore. If pl/pgsql is installed in template1, then the restore fails. And I couldn't find any solution to this on the list either. I definitely want pl/pgsql in template1 so that any databases I create have access to pl/pgsql without having

Re: [GENERAL] normal user dump gives error because of plpgsql

2005-03-10 Thread Martijn van Oosterhout
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