Message-ID: <4F4820C8.2000703@iii.com>
Date: Fri, 24 Feb 2012 15:44:08 -0800
From: Dinesh Bhandary <dbhandary@iii.com>
Reply-To: dbhandary@iii.com
Organization: Innovative Interfaces
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64;
	rv:8.0) Gecko/20111105 Thunderbird/8.0
MIME-Version: 1.0
To: pgsql-admin@postgresql.org
Subject: Re: Problems with pg_restore (plpgsql already exists)
References: <EB254343-461B-4B6B-93A1-3065BA902CF3@gmail.com>
In-Reply-To: <EB254343-461B-4B6B-93A1-3065BA902CF3@gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

one way to get over this issue is to do  pg_dump of postgres 8.4 db 
using postgres 9.1.2 binaries.
Here is a note from postgres 9.1.2 documentation

"In a default PostgreSQL installation, the handler for the PL/pgSQL 
language is built and installed into the "library" directory; 
furthermore, the PL/pgSQL language itself is installed in all databases. 
If Tcl support is configured in, the handlers for PL/Tcl and PL/TclU are 
built and installed in the library directory, but the language itself is 
not installed in any database by default. Likewise, the PL/Perl and 
PL/PerlU handlers are built and installed if Perl support is configured, 
and the PL/PythonU handler is installed if Python support is configured, 
but these languages are not installed by default."

hope this helps.

Thanks.
Dinesh

On 2/24/2012 2:30 PM, Brian Weaver wrote:
> CREATE DATABASE foo WITH TEMPLATE = template0 ENCODING = 'UTF8' LC_COLLATE = 'en_US.UTF-8' LC_CTYPE = 'en_US.UTF-8';