Re: [HACKERS] Prepared statements assume text type in PG10

2017-10-07 Thread Tom Lane
Jack Christensen writes: > Pre-version 10: > jack=# prepare ps as select $1; > ERROR:  could not determine data type of parameter $1 > But on PG10 the type defaults to text: > jack=# prepare ps as select $1; > PREPARE > I looked through the git log and couldn't find any commits referencing >

Re: [HACKERS] Prepared statements assume text type in PG10

2017-10-07 Thread Peter Geoghegan
On Sat, Oct 7, 2017 at 4:27 PM, Peter Geoghegan wrote: > I suspect commit d8d32d9 is involved here, though I haven't verified that. Weirdly, there is a git hash collision here, so you'll have to put in d8d32d9a (8 characters -- the default of 7 for a short git hash isn't cutting it). -- Peter G

Re: [HACKERS] Prepared statements assume text type in PG10

2017-10-07 Thread Peter Geoghegan
On Sat, Oct 7, 2017 at 2:56 PM, Jack Christensen wrote: > The test suite for the Go PostgreSQL driver pgx > (https://github.com/jackc/pgx) found an unexpected behavior change in PG10. > Previously, it was impossible to prepare a statement with a unknown or > ambiguous parameter type. > > Pre-versi