replication connection and multi-command queries

Поиск
Список
Период
Сортировка
От Greg Rychlewski
Тема replication connection and multi-command queries
Дата
Msg-id CAKemG7Vejiga7yx5qM9MO+9HXzuE4RJ4gcf1VXeXQfCY3tKPEw@mail.gmail.com
обсуждение исходный текст
Ответы Re: replication connection and multi-command queries  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Jean Baro
Дата:
Сообщение: Could this "tool" one day be part of PostgreSQL native features? I reckon it would be useful for most PG user.
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: replication connection and multi-command queries