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.klaver@xxxxxxxxxxx