On 02/14/2013 03:11 PM, John R Pierce wrote:
On 2/14/2013 7:06 AM, James B. Byrne wrote:
CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;
plpgsql is a LANGUAGE, not an extension, I thought?
you use CREATE LANGUAGE to enable it..
http://www.postgresql.org/docs/9.2/interactive/
On 2/14/2013 7:06 AM, James B. Byrne wrote:
CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;
plpgsql is a LANGUAGE, not an extension, I thought?
you use CREATE LANGUAGE to enable it..
--
john r pierce 37N 122W
somewhere on the middle of the
On Thu, February 14, 2013 06:23, Guillaume Lelarge wrote:
> On Tue, 2013-02-12 at 15:32 -0500, James B. Byrne wrote:
>> PG-9.2
>> PGAdmin3-1.16.0
>>
>> I am attempting to do this from inside PGAdmin3 but I find that I no
>> longer see either template0 or template1 in the object tree. Where
>> ar
On Tue, 2013-02-12 at 15:32 -0500, James B. Byrne wrote:
> PG-9.2
> PGAdmin3-1.16.0
>
> I have run into an old problem wherein the postgres user has ownership
> of the PSQL language extension in a newly created database. I wish to
> remove this extension from template1 as the database is automati
PG-9.2
PGAdmin3-1.16.0
I have run into an old problem wherein the postgres user has ownership
of the PSQL language extension in a newly created database. I wish to
remove this extension from template1 as the database is automatically
recreated on every test run and I am unable to specify template
