[HACKERS] Prepared statements assume text type in PG10 - Mailing list pgsql-hackers

From Jack Christensen
Subject [HACKERS] Prepared statements assume text type in PG10
Date
Msg-id 9728d447-2856-27e2-24f7-d889d61d0fb9@jackchristensen.com
Whole thread Raw
Responses Re: [HACKERS] Prepared statements assume text type in PG10
Re: [HACKERS] Prepared statements assume text type in PG10
List pgsql-hackers
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-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
Time: 0.183 ms
jack=# execute ps('Hello, there');   ?column?
-------------- Hello, there
(1 row)

Time: 0.437 ms

I looked through the git log and couldn't find any commits referencing 
this. Is this an intended behavior change?

Jack





-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

pgsql-hackers by date:

Previous
From: Petr Jelinek
Date:
Subject: Re: [HACKERS] Discussion on missing optimizations
Next
From: Mark Kirkwood
Date:
Subject: Re: [HACKERS] tablespaces inside $PGDATA considered harmful