Re: rw_redis_fdw: SQL Errors when statement is within a function - Mailing list pgsql-general

From GPT
Subject Re: rw_redis_fdw: SQL Errors when statement is within a function
Date
Msg-id CADep2PN_T+frUJG07oKRJ0DfUALuuoaSbvKq_nposNNaSWjX2w@mail.gmail.com
Whole thread Raw
In response to Re: rw_redis_fdw: SQL Errors when statement is within a function  (Andres Freund <andres@anarazel.de>)
Responses Re: rw_redis_fdw: SQL Errors when statement is within a function  (Christoph Moench-Tegeder <cmt@burggraben.net>)
List pgsql-general
So, this kind of switch after a few goes is a normal behavior or
something unexpected which will change in future?

I am asking in order to have my mind on incidents with similar behavior.

Tia


On 10/25/18, Andres Freund <andres@anarazel.de> wrote:
> Hi,
>
> On 2018-10-25 11:43:39 +0200, GPT wrote:
>> I have faced an incident which, according to the developer, "The
>> problem seems to be that pgsql switches from a CONST sub-expression
>> into a FUNCEXPR after a few goes, ..."
>>
>> Please have a look at the following two links which describe the problem:
>>
>> https://github.com/nahanni/rw_redis_fdw/issues/13
>> https://github.com/nahanni/rw_redis_fdw/issues/14
>>
>> The first link (13) has to do with PG10.x version.
>> The second one (14) has to do with PG11 version in which the developer
>> traces the "problem".
>>
>> Please check and comment.
>
> The developer of the FDW seems to have made the requisite fixes. I'm not
> sure what you'd like us to do?
>
> Greetings,
>
> Andres Freund
>


pgsql-general by date:

Previous
From: Ravi Krishna
Date:
Subject: Re: Compile and build portable postgresql for mac
Next
From: Bruno Wolff III
Date:
Subject: Re: Should pg 11 use a lot more memory building an spgist index?