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

From Janning Vygen
Subject Re: normal user dump gives error because of plpgsql
Date
Msg-id 200503140921.39900.vygen@gmx.de
Whole thread Raw
In response to Re: normal user dump gives error because of plpgsql  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Am Donnerstag, 10. März 2005 18:17 schrieb Tom Lane:
> John Sidney-Woollett <johnsw@wardbrook.com> 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 template0,
> not template1.

Thanks! I just didn't read the manual careful enough. Sorry for stealing your
time as it is 10 times worth than mine, i guess.

> > Can pg_restore be made to ignore the error?
>
> It does, at least since 8.0.

I guess, it's time to upgrade!

kind regards,
Janning

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: [PATCHES] A way to let Vacuum warn if FSM settings are low. [final?]
Next
From: Richard Huxton
Date:
Subject: Re: Convert Cursor to array