CREATE EXTENSION does not seem to work in 9.2

From: Susan Cassidy <susan(dot)cassidy(at)decisionsciencescorp(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: CREATE EXTENSION does not seem to work in 9.2
Date: 2014-01-21 22:51:29
Message-ID: CAE3Q8o=Qu80fkhrDdXSseOmCAaLS4tp1y2ZYUtcXYoEY4w1o-Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

When I tried to do CREATE EXTENSION IF NOT EXISTS
/usr/pgsql-9.2/share/extension/plpgsql.control with schema public;

it gave me
ERROR: syntax error at or near "EXTENSION"

CREATE LANGUAGE worked just fine. I only tried CREATE EXTENSION because
the manual said that CREATE LANGUAGE was deprecated.

Susan

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2014-01-21 23:05:42 Re: CREATE EXTENSION does not seem to work in 9.2
Previous Message Ken Tanzer 2014-01-21 22:15:11 Re: pg_config problems on PG9.3/Centos?