Re: create (or replace) language

Поиск
Список
Период
Сортировка
От Dave Page
Тема Re: create (or replace) language
Дата
Msg-id CA+OCxoy9KEDxrTi7yT_8q-YHhGG3ihnaTTpfn7oTdQ-gEMCnHQ@mail.gmail.com
обсуждение исходный текст
Ответ на create (or replace) language  (Michal Kozusznik <kozusznik.michal@ifortuna.cz>)
Ответы Re: create (or replace) language
Список pgadmin-support


On Mon, Jun 18, 2012 at 4:09 PM, Michal Kozusznik <kozusznik.michal@ifortuna.cz> wrote:
While performing db dump (from postgresql 8.4), pgAdmin stores CREATE LANGUAGE in following way:

CREATE OR REPLACE PROCEDURAL LANGUAGE plpgsql;

This syntax is not compatible with postgresql 8.4
OR REPLACE has been added in v9.0


pgAdmin doesn't create the dump file - it just calls pg_dump. Make sure you have the correct version of pg_dump in the directory pointed to by the PG Bin Path setting on File -> Options dialog.


--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

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

Предыдущее
От: Michal Kozusznik
Дата:
Сообщение: create (or replace) language
Следующее
От: Michal Kozusznik
Дата:
Сообщение: Re: create (or replace) language