Re: CREATE EXTENSION does not seem to work in 9.2

Поиск
Список
Период
Сортировка
От Susan Cassidy
Тема Re: CREATE EXTENSION does not seem to work in 9.2
Дата
Msg-id CAE3Q8o=-9-AVGRU-d-3Hvney6xYypAir8YM-hTnfUYXfXdCizw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: CREATE EXTENSION does not seem to work in 9.2  (Adrian Klaver <adrian.klaver@gmail.com>)
Ответы Re: CREATE EXTENSION does not seem to work in 9.2
Re: CREATE EXTENSION does not seem to work in 9.2
Список pgsql-general
Дерево обсуждения
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.klaver@gmail.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.klaver@gmail.com

В списке pgsql-general по дате отправления:

Предыдущее
От: Marti Raudsepp
Дата:
Сообщение: Re: 9.3.2 server creates hundreds of thousands of temporary files
Следующее
От: Moshe Jacobson
Дата:
Сообщение: Re: question on writing a function