| 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: | Whole Thread | Raw Message | 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
| 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. |