On Thu, February 21, 2013 12:38, James B. Byrne wrote:
> I am trying, without success, to create a PG-9.2 database without
> including the plpgsql extension. I have tried specifying template0
> and the database is nonetheless created with plpgsql. I have deleted
> plpgsql from template1 and the new database is nonetheless created
> with plpgsql.
>
> I desire to remove plpgsql from newly created databases because the
> dump that is generated by pgdump contains this line:
>
> CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;
>
Wrong line. This is the line
COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';
And yes, I went through this a year ago with PG-9.1 and resolved it
once by switching to template0 in the connection configuration. Now it
is back with PG-9.2. using the exact same configuration code because
evidently plpgsql is added regardless.
--=20
*** E-Mail is NOT a SECURE channel ***
James B. Byrne mailto:ByrneJB@Harte-Lyne.ca
Harte & Lyne Limited http://www.harte-lyne.ca
9 Brockley Drive vox: +1 905 561 1241
Hamilton, Ontario fax: +1 905 561 0757
Canada L8E 3C3