public inbox for [email protected]  

help / color / mirror / Atom feed

From: Greg Rychlewski <[email protected]>
To: [email protected]
Subject: replication connection and multi-command queries
Date: Sun, 23 Jan 2022 18:47:36 -0500
Message-ID: <CAKemG7Vejiga7yx5qM9MO+9HXzuE4RJ4gcf1VXeXQfCY3tKPEw@mail.gmail.com> (raw)

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

view thread (7+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: replication connection and multi-command queries
  In-Reply-To: <CAKemG7Vejiga7yx5qM9MO+9HXzuE4RJ4gcf1VXeXQfCY3tKPEw@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox