create (or replace) language

From: Michal Kozusznik <kozusznik(dot)michal(at)ifortuna(dot)cz>
To: <pgadmin-support(at)postgresql(dot)org>
Subject: create (or replace) language
Date: 2012-06-18 15:09:20
Message-ID: 4FDF44A0.40302@ifortuna.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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

Reference
http://www.postgresql.org/docs/8.4/static/sql-createlanguage.html

Also "PROCEDURAL" keyword does nothing and may be skipped.

tested with pgAdmin 1.14.0, 1.14.2, 1.14.3
on postgresql 8.4

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Dave Page 2012-06-18 15:18:10 Re: create (or replace) language
Previous Message Guillaume Lelarge 2012-06-18 15:02:38 Re: RI_ConstraintTrigger