| From: | Dave Page <dpage(at)pgadmin(dot)org> |
|---|---|
| To: | Michal Kozusznik <kozusznik(dot)michal(at)ifortuna(dot)cz> |
| Cc: | pgadmin-support(at)postgresql(dot)org |
| Subject: | Re: create (or replace) language |
| Date: | 2012-06-18 15:18:10 |
| Message-ID: | CA+OCxoy9KEDxrTi7yT_8q-YHhGG3ihnaTTpfn7oTdQ-gEMCnHQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support |
On Mon, Jun 18, 2012 at 4:09 PM, Michal Kozusznik <
kozusznik(dot)michal(at)ifortuna(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michal Kozusznik | 2012-06-18 15:21:34 | Re: create (or replace) language |
| Previous Message | Michal Kozusznik | 2012-06-18 15:09:20 | create (or replace) language |