Re: 8.2/8.3 incompatibility - Mailing list pgsql-general

From Gregory Williamson
Subject Re: 8.2/8.3 incompatibility
Date
Msg-id 8B319E5A30FF4A48BE7EEAAF609DB233015E3314@COMAIL01.digitalglobe.com
Whole thread Raw
In response to 8.2/8.3 incompatibility  (Harald Fuchs <hari.fuchs@googlemail.com>)
Responses Re: 8.2/8.3 incompatibility
List pgsql-general

Harald,
>
> I've found an incompatibility between PostgreSQL 8.2.4 and 8.3.0 which
> is not clearly documented.  Here's a short example:

<...>

> (Note the different column types.)
>

Precisely -- there are a number of casts that have been removed from this release. You can find details in the release notes. A pain, to be sure, but apparently under-the-hood this helps make things saner.

You can create your own cast or modify the DDL to be sane.

HTH,

Greg Williamson
Senior DBA
GlobeXplorer LLC, a DigitalGlobe company

Confidentiality Notice: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information and must be protected in accordance with those provisions. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.

(My corporate masters made me say this.)

pgsql-general by date:

Previous
From: Gregory Stark
Date:
Subject: Re: Kernel kills postgres process - help need
Next
From: "Kurt Schroeder"
Date:
Subject: Re: Fossology Install & Config Issues...