Re: Prepared Statements

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Prepared Statements
Дата
Msg-id 3944.1058853363@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Prepared Statements  (Peter Kovacs <peter.kovacs@siemens.com>)
Ответы Re: Prepared Statements  (Peter Kovacs <peter.kovacs@siemens.com>)
Список pgsql-jdbc
Peter Kovacs <peter.kovacs@siemens.com> writes:
> I think that the simplest thing would be to have an option in the
> backend to disable processing of multiple statements in one query --
> i.e. disallow the use of ';' as a separator of statements.

FWIW, the new "extended query" protocol has exactly such a restriction.
However that hardly excuses any sloppiness in allowing
non-syntax-checked parameter values through.  Consider changing
"WHERE x < ?" to
"WHERE x < 42 AND my_function_with_interesting_side_effects()"

No semicolons in sight, but I can still clean out your bank balance ;-)

            regards, tom lane

В списке pgsql-jdbc по дате отправления:

Предыдущее
От: "David Wall"
Дата:
Сообщение: Detecting 'socket errors' - SQLSTATE patch
Следующее
От: peter royal
Дата:
Сообщение: Re: the IN clause saga