Hi,
On 2020-06-04 16:44:53 -0400, Alvaro Herrera wrote:
> A logical replication connection cannot run SQL anyway, can it?
You can:
andres@awork3:~/src/postgresql$ psql 'replication=database'
postgres[52656][1]=# IDENTIFY_SYSTEM;
┌─────────────────────┬──────────┬────────────┬──────────┐
│ systemid │ timeline │ xlogpos │ dbname │
├─────────────────────┼──────────┼────────────┼──────────┤
│ 6821634567571961151 │ 1 │ 1/D256EC40 │ postgres │
└─────────────────────┴──────────┴────────────┴──────────┘
(1 row)
postgres[52656][1]=# SELECT 1;
┌──────────┐
│ ?column? │
├──────────┤
│ 1 │
└──────────┘
(1 row)
I am very much not in love with the way that was implemented, but it's
there, and it's used as far as I know (cf tablesync.c).
Greetings,
Andres Freund