replication connection and multi-command queries - Mailing list pgsql-novice

From Greg Rychlewski
Subject replication connection and multi-command queries
Date
Msg-id CAKemG7Vejiga7yx5qM9MO+9HXzuE4RJ4gcf1VXeXQfCY3tKPEw@mail.gmail.com
Whole thread Raw
Responses Re: replication connection and multi-command queries
List 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

pgsql-novice by date:

Previous
From: Jean Baro
Date:
Subject: Could this "tool" one day be part of PostgreSQL native features? I reckon it would be useful for most PG user.
Next
From: "David G. Johnston"
Date:
Subject: Re: replication connection and multi-command queries