2010/2/19 Tom Lane <tgl@sss.pgh.pa.us>:
> Takahiro Itagaki <itagaki.takahiro@oss.ntt.co.jp> writes:
>> David Fetter <david@fetter.org> wrote:
>>> support both pre-9.0 and post-9.0 PostgreSQLs. David Wheeler has
>>> suggested that we special-case PL/pgsql for 9.0 and greater, as it's
>>> in template0, where those tests are based.
>
>> +1 for the CREATE LANGUAGE IF NOT EXISTS behavior.
>
>> The regression test in the core is targeting only its version,
>> but some external projects have version-independent tests.
>
> I think it's more like "are under the fond illusion that their tests are
> version-independent". Are we going to back out the next incompatible
> change we choose to make as soon as somebody notices that it breaks a
> third-party test case? I don't think so. Let me point out that
> choosing to install plpgsql by default has already broken "--single"
> restore of practically every pg_dump out there. Nobody batted an eye
> about that. Why are we suddenly so concerned about its effects on
> unnamed test suites?
Oh yeah, that one is very annoying, can we go fix that one somehow?
I think the use of --single has decreased a lot in favor of parallel
restore, but it's certainly not all that uncommon... I think the main
reason we haven't heard loads of complains is that it isn't the
default..
-- Magnus HaganderMe: http://www.hagander.net/Work: http://www.redpill-linpro.com/