On 2020-Jun-04, Andres Freund wrote:
> 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).
Ouch ... so they made IDENT in the replication grammar be a trigger to
enter the regular grammar. Crazy. No way to put those worms back in
the tin now, I guess.
It is still my opinion that we should prohibit a logical replication
connection from being used to do physical replication. Horiguchi-san,
Sawada-san and Masao-san are all of the same opinion. Dave Cramer (of
the JDBC team) is not opposed to the change -- he says they're just
using it because they didn't realize they should be doing differently.
Both Michael P. and you are saying we shouldn't break it because it
works today, but there isn't a real use-case for it.
--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services