| From: | Janning Vygen <vygen(at)gmx(dot)de> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: normal user dump gives error because of plpgsql |
| Date: | 2005-03-14 08:21:39 |
| Message-ID: | 200503140921.39900.vygen@gmx.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Am Donnerstag, 10. März 2005 18:17 schrieb Tom Lane:
> John Sidney-Woollett <johnsw(at)wardbrook(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Huxton | 2005-03-14 08:30:32 | Re: Convert Cursor to array |
| Previous Message | Simon Riggs | 2005-03-14 08:17:48 | Re: [GENERAL] A way to let Vacuum warn if FSM settings |