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@postgresql.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 */
