Re: rw_redis_fdw: SQL Errors when statement is within a function

From: GPT <gptmailinglists(at)gmail(dot)com>
To: Andres Freund <andres(at)anarazel(dot)de>
Cc: pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: rw_redis_fdw: SQL Errors when statement is within a function
Date: 2018-10-25 14:54:39
Message-ID: CADep2PN_T+frUJG07oKRJ0DfUALuuoaSbvKq_nposNNaSWjX2w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)anarazel(dot)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
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruno Wolff III 2018-10-25 17:43:06 Re: Should pg 11 use a lot more memory building an spgist index?
Previous Message Ravi Krishna 2018-10-25 14:39:29 Re: Compile and build portable postgresql for mac