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

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: greg(dot)rychlewski(at)gmail(dot)com
Subject: BUG #17379: Cannot issue multi-command statements using a replication connection
Date: 2022-01-24 01:10:49
Message-ID: 17379-6a5c6cfb3f1f5e77@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 17379
Logged by: Greg Rychlewski
Email address: greg(dot)rychlewski(at)gmail(dot)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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message B Ganesh Kishan 2022-01-24 05:55:11 RE: BUG #17375: RECOVERY TARGET TIME RESTORE IS FAILING TO START SERVER
Previous Message Tom Lane 2022-01-23 19:20:54 Re: BUG #17378: WRONG VALUE ON - A.2. Time Zones