From: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
---|---|
To: | "James B(dot) Byrne" <byrnejb(at)harte-lyne(dot)ca> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Need help extripating plpgsql |
Date: | 2013-02-21 20:56:32 |
Message-ID: | 51268A00.5020406@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 02/21/2013 09:38 AM, 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;
>
> And for some reason this statement causes my test suit to fail with
> this error:
>
> psql:/home/byrnejb/Projects/Software/theHeart/code/proforma_rails_3_2/db/structure.sql:22:
> ERROR: must be owner of extension plpgsql
>
> I do not understand why this happens since, as I read this, if the
> plpgsql extension already exists in the database, which it does, then
> this statement should not be executed at all. But it does. Further,
> I do not understand why or how plpgsql is being included into
> databases on create as I have removed it from template1 and it does
> not exist in template0 to begin with.
Actually it does exist in template0.
--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2013-02-21 21:02:40 | Re: Need help extripating plpgsql |
Previous Message | Kevin Grittner | 2013-02-21 20:46:53 | Re: Database corruption event, unlockable rows, possibly bogus virtual xids? Invalid backend server xid |