Re: Postgresql 9.5 and Shell scripts/variables vs. C programming/defining a value to be used

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Postgresql 9.5 and Shell scripts/variables vs. C programming/defining a value to be used
Дата
Msg-id CAKFQuwb-iiuL6x0kwbrWJ_suenCpN8UQ-HuO+xx+N_GXT7m=Xg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Postgresql 9.5 and Shell scripts/variables vs. C programming/defining a value to be used  (Poul Kristensen <bcc5226@gmail.com>)
Ответы Re: Postgresql 9.5 and Shell scripts/variables vs. C programming/defining a value to be used  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Дерево обсуждения
On Wed, Nov 23, 2016 at 3:46 AM, Poul Kristensen <bcc5226@gmail.com> wrote:
In the postgresql.log I get "select datname from $1".

​That is expected when you parameterize a query - the query string includes parameter​s instead of values.  What you are seeing is the "Prepare" component of a "prepare-execute".  When you execute you then see something like; "execute unnamed_query ['pg_database']" (note, I'm not familiar with the exact syntax and terminology that would appear in the log file).

David J.

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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: query locks up when run concurrently
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Postgresql 9.5 and Shell scripts/variables vs. C programming/defining a value to be used