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

On 10/29/18 3:58 AM, GPT wrote:
> Hi, I had a wonderful Sunday, and have no intention to change that sense!
>
> Dear PG developers, young and/or middle age, and rest users, please
> check the errors the PG gave me.

> happen as Adrian wrote, and life goes on.
>
> What I would like to ask from developers is:
>
> Please, if possible improve the error system!

The improvement is already there:

https://github.com/nahanni/rw_redis_fdw/issues/14

"Turning on debugging, the first 5 tries parses the where clause as:"

For more information see:

https://www.postgresql.org/docs/10/static/runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHEN

In particular: Table 19.1. Message Severity Levels.

>
> Especially when there are internal changes which may affect
> dynamically the outcome (from expected results to ERROR or whatever)
> of a correct statement. For example, the error would include a
> note/warning similar to "... after change of plan" or "... . Plan was
> changed". Such a note/warning would have saved the whole situation and
> I would have something in my hand to search and ask for help from the
> very beginning.
>
> As a simple end-user and not an IT folk, I have absolutely no word on
> what and how things happen under the hood. But I expect the best
> response, even if an error has appeared, which will safely enlighten
> me at the shortest time. Your time is valuable, my time, too. So,
> let´s respect our times and do the best to protect them against waste
> in future.
>
> Thanks and have a nice day and a wonderful week!
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com