Thread: pg_dump should not try CREATE OR REPLACE LANGUAGE < 9.0

pg_dump should not try CREATE OR REPLACE LANGUAGE < 9.0

From
Greg Sabino Mullane
Date:
Subject line kind of says it all: LANGUAGE replacement was
introduced in 9.0, but pg_dump is trying it on all versions.

--
Greg Sabino Mullane greg@turnstep.com
End Point Corporation
PGP Key: 0x14964AC8 201005121537
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8

Attachment

Re: pg_dump should not try CREATE OR REPLACE LANGUAGE < 9.0

From
Tom Lane
Date:
Greg Sabino Mullane <greg@turnstep.com> writes:
> Subject line kind of says it all: LANGUAGE replacement was 
> introduced in 9.0, but pg_dump is trying it on all versions.

So?  pg_dump output is never promised to load into older server
versions.

The proposed patch is quite wrong anyway, because it is looking at
the source server version, not the (unknowable) target version.
        regards, tom lane