Postgres Pro
Downloads
Home   >   mailing lists

Re: create (or replace) language - Mailing list pgadmin-support

From Dave Page
Subject Re: create (or replace) language
Date
Msg-id CA+OCxoy9KEDxrTi7yT_8q-YHhGG3ihnaTTpfn7oTdQ-gEMCnHQ@mail.gmail.com
Whole thread Raw
In response to create (or replace) language  (Michal Kozusznik <kozusznik.michal@ifortuna.cz>)
Responses Re: create (or replace) language  (Michal Kozusznik <kozusznik.michal@ifortuna.cz>)
List pgadmin-support
Tree view


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 by date:

Previous
From: Michal Kozusznik
Date:
Subject: create (or replace) language
Next
From: Michal Kozusznik
Date:
Subject: Re: create (or replace) language