[HACKERS] Prepared statements assume text type in PG10

Поиск
Список
Период
Сортировка
От Jack Christensen
Тема [HACKERS] Prepared statements assume text type in PG10
Дата
Msg-id 9728d447-2856-27e2-24f7-d889d61d0fb9@jackchristensen.com
обсуждение исходный текст
Ответы Re: [HACKERS] Prepared statements assume text type in PG10  (Peter Geoghegan <pg@bowt.ie>)
Re: [HACKERS] Prepared statements assume text type in PG10  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Petr Jelinek
Дата:
Сообщение: Re: [HACKERS] Discussion on missing optimizations
Следующее
От: Mark Kirkwood
Дата:
Сообщение: Re: [HACKERS] tablespaces inside $PGDATA considered harmful