Re: BUG #15289: Type inference of parameters in prepared statementscan sometimes fail or succeed, depending... - Mailing list pgsql-bugs

From David G. Johnston
Subject Re: BUG #15289: Type inference of parameters in prepared statementscan sometimes fail or succeed, depending...
Date
Msg-id CAKFQuwZg5H0e8Yb6q8UDMo6_9nkL2uq_tcQEkc+--mwy66e4Eg@mail.gmail.com
Whole thread Raw
In response to BUG #15289: Type inference of parameters in prepared statements cansometimes fail or succeed, depending...  (PG Bug reporting form <noreply@postgresql.org>)
Responses Re: BUG #15289: Type inference of parameters in prepared statementscan sometimes fail or succeed, depending...  (Nick Farmer <farmernick-pg@varteg.nz>)
List pgsql-bugs
On Saturday, July 21, 2018, PG Bug reporting form <noreply@postgresql.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.

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #15289: Type inference of parameters in prepared statements can sometimes fail or succeed, depending...
Next
From: Tom Lane
Date:
Subject: Re: LLVM jit and window functions on a temporary table