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 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
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
