Re: Avoiding upgrade backlash - Mailing list pgsql-advocacy

From Bernd Helmle
Subject Re: Avoiding upgrade backlash
Date
Msg-id 9AA942690F2E0B8A997D26F1@imhotep.credativ.de
Whole thread Raw
In response to Re: Avoiding upgrade backlash  (Stefan Kaltenbrunner <stefan@kaltenbrunner.cc>)
List pgsql-advocacy
--On Dienstag, November 13, 2007 11:05:18 +0100 Stefan Kaltenbrunner
<stefan@kaltenbrunner.cc> wrote:

>> What difference would pg_dump make?
>
> well the current problem is that either way pg_dump can generate dumps
> that are not restorable without modification on 8.3 (like say one that
> contains a VIEW that does a INTEGER = TEXT comparision which 8.3 will
> refuse to create) even if dumped with 8.3.

AFAIK pg_dump and its related dump routines takes care to dump this in a
proper way with explicit casts attached. Do you have an example showing a
possible misbehavior?

--
  Thanks

                    Bernd

pgsql-advocacy by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Avoiding upgrade backlash
Next
From: Tom Lane
Date:
Subject: Re: [DOCS] Avoiding upgrade backlash