Re: CREATE EXTENSION does not seem to work in 9.2

It wasn't installed in the yum package that we used to install postgres
9.2. I had to add it. As I said, create language worked fine. Before I
did create language, I got errors that the language didn't exist when I
tried to create a function. After I created the language, those errors
went away.

Susan

On Tue, Jan 21, 2014 at 3:05 PM, Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>wrote:

> 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(dot)klaver(at)gmail(dot)com
>