Re: BUG #15289: Type inference of parameters in prepared statements can sometimes fail or succeed, depending...

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: "farmernick-pg(at)varteg(dot)nz" <farmernick-pg(at)varteg(dot)nz>, "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: BUG #15289: Type inference of parameters in prepared statements can sometimes fail or succeed, depending...
Date: 2018-07-21 16:48:52
Message-ID: CAKFQuwZg5H0e8Yb6q8UDMo6_9nkL2uq_tcQEkc+--mwy66e4Eg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Saturday, July 21, 2018, PG Bug reporting form <noreply(at)postgresql(dot)org>
wrote:

> I can accept either behaviour
> (though the former is more useful); it's the fact that I get both that's
> unwelcome.
>

But each of those behaviors is consistently encountered every time the
query is run so there isn't any hidden danger involved here; compared to if
the error only occurred if certain data was encountered during execution.
As Tom said, while a bit inconcsistent the effort to fix outweighs the the
fact there is no actual problem, just an unexpected dependency on the
written query.

David J.

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2018-07-21 20:33:08 Re: LLVM jit and window functions on a temporary table
Previous Message Tom Lane 2018-07-21 15:23:36 Re: BUG #15289: Type inference of parameters in prepared statements can sometimes fail or succeed, depending...