From: Brian Weaver <cmdrclueless@gmail.com>
To: Guillaume Lelarge <guillaume@lelarge.info>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Problems with pg_restore (plpgsql already exists)
Date: Sat, 25 Feb 2012 11:18:24 -0500
Message-ID: <17919563-C079-438C-9702-5A0806127DFD@gmail.com> (raw)
In-Reply-To: <1330183903.2593.1.camel@localhost.localdomain>
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>
Guillaume,
Thanks for the pointer. Is it just me that finds it the behavior of pg_restore odd? If the default installation since 9.0 has PL/PgSQL installed then why does pg_restore still emit statements to create the language? As a developer by trade it smells like a bug.
-- Brian
Sent from my iPhone
On Feb 25, 2012, at 10:31, Guillaume Lelarge <guillaume@lelarge.info> 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 standard
>> 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.
>>
>> Seems like a fairly substantial change. Did I miss it in the release notes?
>>
>
> 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.
>
>
> --
> Guillaume
> http://blog.guillaume.lelarge.info
> http://www.dalibo.com
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: cmdrclueless@gmail.com, guillaume@lelarge.info
Subject: Re: Problems with pg_restore (plpgsql already exists)
In-Reply-To: <17919563-C079-438C-9702-5A0806127DFD@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox