Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id A59CC4A2A39 for ; Sat, 25 Feb 2012 12:18:44 -0400 (AST) Received: from mail-yx0-f174.google.com ([209.85.213.174]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1S1KKX-0003Gc-UB for pgsql-admin@postgresql.org; Sat, 25 Feb 2012 16:18:43 +0000 Received: by yenm8 with SMTP id m8so1562723yen.19 for ; Sat, 25 Feb 2012 08:18:28 -0800 (PST) Received-SPF: pass (google.com: domain of cmdrclueless@gmail.com designates 10.236.77.102 as permitted sender) client-ip=10.236.77.102; Authentication-Results: mr.google.com; spf=pass (google.com: domain of cmdrclueless@gmail.com designates 10.236.77.102 as permitted sender) smtp.mail=cmdrclueless@gmail.com; dkim=pass header.i=cmdrclueless@gmail.com Received: from mr.google.com ([10.236.77.102]) by 10.236.77.102 with SMTP id c66mr12520868yhe.30.1330186708035 (num_hops = 1); Sat, 25 Feb 2012 08:18:28 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=references:in-reply-to:mime-version:content-transfer-encoding :content-type:message-id:cc:x-mailer:from:subject:date:to; bh=IjFs649tiu8wfadAw8zuvpGXXOcvYy5aP7/fm6YIDaY=; b=OmQ+joZkoR2/OBBMq6SZFbzh4vNBjVe99Y3f03ip2xdqvHxxaOph6tDsgMq7GbKo2/ g513m3tBSotEqo6WmVTvuFiJUeNYtcM+YTdP1RFibHUAsMpKgUmVzTJQ96T9KCKio2Xy OsuUb4Xe8idFAgT/DLDF/mpXPUw1UroyCO+pI= Received: by 10.236.77.102 with SMTP id c66mr9412980yhe.30.1330186707984; Sat, 25 Feb 2012 08:18:27 -0800 (PST) Received: from [10.128.64.24] (cpe-174-099-095-235.nc.res.rr.com. [174.99.95.235]) by mx.google.com with ESMTPS id 34sm13781512anu.6.2012.02.25.08.18.26 (version=TLSv1/SSLv3 cipher=OTHER); Sat, 25 Feb 2012 08:18:27 -0800 (PST) References: <4F4820C8.2000703@iii.com> <1330183903.2593.1.camel@localhost.localdomain> In-Reply-To: <1330183903.2593.1.camel@localhost.localdomain> Mime-Version: 1.0 (1.0) Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii Message-Id: <17919563-C079-438C-9702-5A0806127DFD@gmail.com> Cc: "pgsql-admin@postgresql.org" X-Mailer: iPhone Mail (9A405) From: Brian Weaver Subject: Re: Problems with pg_restore (plpgsql already exists) Date: Sat, 25 Feb 2012 11:18:24 -0500 To: Guillaume Lelarge X-Pg-Spam-Score: -1.7 (-) X-Archive-Number: 201202/104 X-Sequence-Number: 39164 Guillaume,=20 Thanks for the pointer. Is it just me that finds it the behavior of pg_resto= re odd? If the default installation since 9.0 has PL/PgSQL installed then wh= y does pg_restore still emit statements to create the language? As a develop= er by trade it smells like a bug.=20 -- Brian Sent from my iPhone On Feb 25, 2012, at 10:31, Guillaume Lelarge wrote:= > On Fri, 2012-02-24 at 22:12 -0500, Brian Weaver wrote: >> So when did the installation of PL/PgSQL into all databases become standa= rd >> operating procedure? It wasn't standard (or at least it didn't choke) on >> the installation of versions 8.3 and 8.4 that I have used on CentOS 5. >>=20 >> Seems like a fairly substantial change. Did I miss it in the release note= s? >>=20 >=20 > Since 9.0, it's the third item in the overview list of the release notes > http://www.postgresql.org/docs/9.0/static/release-9-0.html. >=20 >=20 > --=20 > Guillaume > http://blog.guillaume.lelarge.info > http://www.dalibo.com >=20