Re: CREATE EXTENSION does not seem to work in 9.2

On 01/21/2014 02:51 PM, Susan Cassidy wrote:
> 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.

If you trying to install plpgsql it is installed by default from 9.0+
If you trying to install something else you only need the extension name
not the file path, so just plpgsql in this case.

>
> Susan


--
Adrian Klaver
adrian.klaver@gmail.com