replication connection and multi-command queries

From: Greg Rychlewski <greg(dot)rychlewski(at)gmail(dot)com>
To: pgsql-novice(at)lists(dot)postgresql(dot)org
Subject: replication connection and multi-command queries
Date: 2022-01-23 23:47:36
Message-ID: CAKemG7Vejiga7yx5qM9MO+9HXzuE4RJ4gcf1VXeXQfCY3tKPEw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi,

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;". I'm receiving a syntax error like this:

%{code: :syntax_error, file: "repl_scanner.l", line: "225", message:
> "syntax error", pg_code: "42601", routine: "replication_yyerror", severity:
> "ERROR", unknown: "ERROR"}

The above is formatted by the driver library I am using, but might have
some useful info.

I was curious: is it by design that replications can't use multiple
commands? I just want to make sure I'm not doing something wrong.

Thanks for your help,
Greg

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message David G. Johnston 2022-01-24 00:16:36 Re: replication connection and multi-command queries
Previous Message Jean Baro 2022-01-07 11:33:48 Could this "tool" one day be part of PostgreSQL native features? I reckon it would be useful for most PG user.