Received-SPF: pass (google.com: domain of cmdrclueless@gmail.com designates
	10.236.182.2 as permitted sender) client-ip=10.236.182.2;
References: <EB254343-461B-4B6B-93A1-3065BA902CF3@gmail.com>
	<4F4820C8.2000703@iii.com>
	<CAAhXZGv+sU3SksPi-hn2GECf2O_-Xt-xBANgCJyuWDwFiUDnAQ@mail.gmail.com>
	<1330183903.2593.1.camel@localhost.localdomain>
	<17919563-C079-438C-9702-5A0806127DFD@gmail.com>
	<274BAD81-38BF-4537-B474-ADCDF77E318A@elevated-dev.com>
	<1330193409.2593.5.camel@localhost.localdomain>
In-Reply-To: <1330193409.2593.5.camel@localhost.localdomain>
Mime-Version: 1.0 (1.0)
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
	charset=us-ascii
Message-Id: <2E7B4488-D6BB-4274-ABE1-74B147244486@gmail.com>
Cc: Scott Ribe <scott_ribe@elevated-dev.com>,
	"pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
From: Brian Weaver <cmdrclueless@gmail.com>
Subject: Re: Problems with pg_restore (plpgsql already exists)
Date: Sat, 25 Feb 2012 14:51:20 -0500
To: Guillaume Lelarge <guillaume@lelarge.info>

Thank you all for the explanation. I'll work around the issue. It's nice to u=
nderstand the thought process even though I might disagree with it.=20

-- Brian

Sent from my iPhone

On Feb 25, 2012, at 13:10, Guillaume Lelarge <guillaume@lelarge.info> wrote:=


> On Sat, 2012-02-25 at 09:23 -0700, Scott Ribe wrote:
>> On Feb 25, 2012, at 9:18 AM, Brian Weaver wrote:
>>=20
>>> Thanks for the pointer. Is it just me that finds it the behavior of pg_r=
estore odd? If the default installation since 9.0 has PL/PgSQL installed the=
n why does pg_restore still emit statements to create the language? As a dev=
eloper by trade it smells like a bug.=20
>>=20
>> It's pg_dump that's emitting the command to create the language. If you r=
an pg_dump from 9.0+, it would not do so.
>=20
> Not quite true. pg_dump from 9.0 does save the language definition, but
> it uses the new CREATE OR REPLACE statement for languages, so that, when
> you restore it in a 9.0+ database that already has the same language, it
> won't complain with an error message.
>=20
> BTW, it isn't odd that pg_dump 9.0 save the language definition. Having
> by default the plpgsql language when you create a database doesn't mean
> you can't drop it.
>=20
>> This is an example of why the standard advice for upgrading is to use the=
 newer pg_dump against the older database
>=20
> Exactly.
>=20
>=20
> --=20
> Guillaume
> http://blog.guillaume.lelarge.info
> http://www.dalibo.com
>=20