BUG #17379: Cannot issue multi-command statements using a replication connection

Поиск
Список
Период
Сортировка
Искать
От
PG Bug reporting form
Тема
BUG #17379: Cannot issue multi-command statements using a replication connection
Дата
Msg-id
17379-6a5c6cfb3f1f5e77@postgresql.org
Список
Дерево обсуждения
BUG #17379: Cannot issue multi-command statements using a replication connection PG Bug reporting form <noreply@postgresql.org>
Re: BUG #17379: Cannot issue multi-command statements using a replication connection Tom Lane <tgl@sss.pgh.pa.us>
Re: BUG #17379: Cannot issue multi-command statements using a replication connection Tom Lane <tgl@sss.pgh.pa.us>
The following bug has been logged on the website:

Bug reference:      17379
Logged by:          Greg Rychlewski
Email address:      greg.rychlewski@gmail.com
PostgreSQL version: 13.5
Operating system:   Mac OS
Description:        

When I issue the following multi-command query on a replication connection I
receive a syntax error:

$psql "dbname=postgres replication=database" -c "select 1;select 2;" 
ERROR:  syntax error

I was curious why this happens, given the documentation at [1] states "In
either physical replication or logical replication walsender mode, only the
simple query protocol can be used." 

For comparison, the following query returns the expected result:

$psql "dbname=postgres replication=database" -c "select 1;" 
 ?column? 
----------
        1

[1] https://www.postgresql.org/docs/current/protocol-replication.html

В списке pgsql-bugs по дате отправления
От: Tom Lane
Дата:
От: B Ganesh Kishan
Дата:
FAQ