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
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 |