Yes, I should know it. thank you.
There are a few sentences about pg_dump syntax compatibility from
postgresql documentation:
Because pg_dump is used to transfer data to newer versions of
PostgreSQL, the output of pg_dump can be expected to load into
PostgreSQL server versions newer than pg_
On Mon, Jun 18, 2012 at 4:09 PM, Michal Kozusznik <
kozusznik.mic...@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
> O
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-createlang
