[postgis-users] postgis.backend and legacy functions

[Paul Ramsey]

You may have to sanitize your function signatures so they are all only
pointing to a single postgis library. Because of the combination of
extension/legacy you've got a mixed set, which is leading to pain.

UPDATE pg_proc SET probin = '$libdir/postgis-2.2'
WHERE probin = '$libdir/postgis-2.1';

Once you are sanitized things should probably be better. This is a
risky big hammer to apply, but it's better than the alternative, if
you're still seeing the 'postgis.backend' messages.

P


On Thu, Feb 25, 2016 at 11:58 AM, Willy-Bas Loos <willybas at gmail.com> wrote:
>
>
> On Thu, Feb 25, 2016 at 9:01 AM, Sandro Santilli <strk at keybit.net> wrote:
>>
>>
>>
>> >  area(geometry) uses postgis-2.1
>> > and st_area(geometry) uses postgis-2.2
>>
>> The best way to fix this would be to update the legacy functions
>> so to have them use postgis-2.2 too.
>>
>
> Thanks for the Reply.
> This seems to be related to https://trac.osgeo.org/postgis/ticket/2382 (in
> which you, strk, seem to have been involved).
> The problem occurs in an unregular fashion. I'm not yet sure about how to
> create it or how to solve it, but both has happened multiple times since
> yesterday.
> The problem is that postgis errors out in most functions, because 'attempt
> to redefine parameter "postgis.backend" '.
> That leaves postgis in a broken state .
>
> I have replaced the legacy functions like you suggested, which worked much
> to my surprise, but did not fix the problem - at least not directly.
> Yesterday i also tried to replace the legacy functions, but then i did not
> work (lots of errors about postgis.backend and functions were not replaced),
> and it did fix the problem for a while.
>
> I will report back when i have clearer info about reproducing.
> One thing that i'm looking into is setting and showing postgis.backend
>
> Cheers,
> --
> Willy-Bas Loos
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/postgis-users