Re: Question about ip4r contrib and PostgreSQL 9.2

From: Merlin Moncure <mmoncure(at)gmail(dot)com>
To: Maxim Boguk <maxim(dot)boguk(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Question about ip4r contrib and PostgreSQL 9.2
Date: 2012-10-02 14:49:13
Message-ID: CAHyXU0ziv=K4w=ugnQ8jD7ZdN1S-BEx5k_0JXHPJGcBMWYZQOQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Sep 27, 2012 at 7:49 PM, Maxim Boguk <maxim(dot)boguk(at)gmail(dot)com> wrote:
> Hi,
>
> One of my project extensively uses ip4r addon (
> http://pgfoundry.org/projects/ip4r/ ).
>
> However, after migration of test environment to 9.2 that addon doesn't
> install anymore without manual fixes.
> Trouble very simple:
> addon use the LANGUAGE 'C' IMMUTABLE STRICT; syntax
> and now language names in PostgreSQL become case-sensitive.
>
> So need replace all these strings with LANGUAGE 'c' IMMUTABLE STRICT;

I just got burned by this. In my case, the pl/r extension failed to
load on 9.2. This is a pretty significant compatibility break IMO.
Why?

merlin

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Hannon 2012-10-02 15:48:20 Long-running query on replica not timing out
Previous Message Peter Geoghegan 2012-10-02 14:24:58 Re: Game Server Lags