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

From Michal Kozusznik
Subject create (or replace) language
Date
Msg-id 4FDF44A0.40302@ifortuna.cz
Whole thread Raw
Responses Re: create (or replace) language  (Dave Page <dpage@pgadmin.org>)
List 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


pgadmin-support by date:

Previous
From: Guillaume Lelarge
Date:
Subject: Re: RI_ConstraintTrigger
Next
From: Dave Page
Date:
Subject: Re: create (or replace) language