Skip site navigation (1) Skip section navigation (2)

Re: Problems with pg_restore (plpgsql already exists)

From: Brian Weaver <cmdrclueless(at)gmail(dot)com>
To:
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Problems with pg_restore (plpgsql already exists)
Date: 2012-02-25 03:12:02
Message-ID: CAAhXZGv+sU3SksPi-hn2GECf2O_-Xt-xBANgCJyuWDwFiUDnAQ@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
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?

-- Brian

On Friday, February 24, 2012, Dinesh Bhandary wrote:

> 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';
>>
>
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/**mailpref/pgsql-admin<http://www.postgresql.org/mailpref/pgsql-admin>
>


-- 

/* insert witty comment here */

In response to

Responses

pgsql-admin by date

Next:From: Guillaume LelargeDate: 2012-02-25 15:31:43
Subject: Re: Problems with pg_restore (plpgsql already exists)
Previous:From: Dinesh BhandaryDate: 2012-02-24 23:44:08
Subject: Re: Problems with pg_restore (plpgsql already exists)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group