Re: normal user dump gives error because of plpgsql

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: John Sidney-Woollett <johnsw(at)wardbrook(dot)com>
Cc: Martijn van Oosterhout <kleptog(at)svana(dot)org>, Janning Vygen <vygen(at)gmx(dot)de>, pgsql-general(at)postgresql(dot)org
Subject: Re: normal user dump gives error because of plpgsql
Date: 2005-03-10 17:17:53
Message-ID: 15964.1110475073@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

> Can pg_restore be made to ignore the error?

It does, at least since 8.0.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2005-03-10 17:22:59 Re: PostgreSQL still for Linux only?
Previous Message John Sidney-Woollett 2005-03-10 17:02:12 Re: normal user dump gives error because of plpgsql