Re: replication connection and multi-command queries

Поиск
Список
Период
Сортировка
От Greg Rychlewski
Тема Re: replication connection and multi-command queries
Дата
Msg-id CAKemG7Xx01ZQ9NWTWtsQJBjzWZbHjPEhq6=gptq9aUh7skm8wg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: replication connection and multi-command queries  ("David G. Johnston" <david.g.johnston@gmail.com>)
Ответы Re: replication connection and multi-command queries  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-novice
Thanks for your reply. To give more context: I am contributing to a Postgres driver used by a programming language. We are currently trying to understand what is legal/not legal to be sent through this connection. 

In the documentation it states that the simple query protocol is followed on these connections, which is why we assumed a multi-command statement would work. I just wanted to make sure we are not doing anything wrong and that it is disallowed by design. We can, for instance, send "SELECT 1;" and receive a result.

On Sun, Jan 23, 2022 at 7:16 PM David G. Johnston <david.g.johnston@gmail.com> wrote:
On Sun, Jan 23, 2022 at 4:47 PM Greg Rychlewski <greg.rychlewski@gmail.com> wrote:
I have a situation where I've set up a replication connection and tried to issue a query with the simple protocol that has multiple commands "SELECT 1; SELECT 2;".

What do you mean by "I've set up a replication connection"?  IIUC they are not intended for interactive usage, they are intended for system-to-system data replication.  If you want to issue queries just connect with a "normal connection".

David J.

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

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: replication connection and multi-command queries
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: replication connection and multi-command queries