Re: [PATCH] Add additional extended protocol commands to psql: \parse and \bind

Поиск
Список
Период
Сортировка
От Anthonin Bonnefoy
Тема Re: [PATCH] Add additional extended protocol commands to psql: \parse and \bind
Дата
Msg-id CAO6_XqpG3a0cCHkhc1HGPGrkNqCttbM3UCqnSTEn+zFCau6Baw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [PATCH] Add additional extended protocol commands to psql: \parse and \bind  (Michael Paquier <michael@paquier.xyz>)
Список pgsql-hackers
On Wed, Jul 24, 2024 at 05:33:07PM +0200, Peter Eisentraut wrote:
> This commit message confused me, because I don't think this is what the
> \bindx command actually does.  AFAICT, it only binds, it does not execute.
> At least that is what the documentation in the content of the patch appears
> to indicate.

Unless I misunderstand the remark, \bindx will call
PQsendQueryPrepared which will bind then execute the query, similar to
what \bind is doing (except \bind also parses the query).

> I'm not sure \bindx is such a great name.  The "x" stands for "I ran out of
> ideas". ;-)

That's definitely what happened :). \bind would have been a better fit
but it was already used.

On Thu, Jul 25, 2024 at 4:19 AM Michael Paquier <michael@paquier.xyz> wrote:
> Not sure that I like much the additional option embedded in the
> existing command; I'd rather keep a separate command for each libpq
> call, that seems cleaner.  So I would be OK with your suggested
> \bind_named.  Fine by me to be outvoted, of course.

+1 keeping this as a separate command and using \bind_named. \bind has
a different behaviour as it also parses the query so keeping them as
separate commands would probably avoid some confusion.



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

Предыдущее
От: shveta malik
Дата:
Сообщение: Re: Logical Replication of sequences
Следующее
От: Peter Smith
Дата:
Сообщение: Re: Logical Replication of sequences