Broken logical replication

2022-01-23 Thread Игорь Выскорко
Giving 2 postgres servers:1. Master -  PostgreSQL 10.162. Slave - PostgreSQL 13.5 Logical replication was configured and worked fine between them. At some point software (russian accounting soft: 1C) which is using master DB, decided to do some db-related tasks. I know only about full reindexing -

Re: Cannot find hstore operator

2022-01-23 Thread Tom Lane
Paul van der Linden writes: > Thanks for the clarification, but giving up performance is a no-go for us. > Also I have my concerns about shemaqualifying each and every use of the -> > operator, there are really a lot of them in my functions and it would > severely impact readability. > Are these t

Re: Cannot find hstore operator

2022-01-23 Thread David G. Johnston
On Sun, Jan 23, 2022 at 7:54 AM Paul van der Linden < paul.doskabou...@gmail.com> wrote: > Thanks for the clarification, but giving up performance is a no-go for us. > > Also I have my concerns about shemaqualifying each and every use of the -> > operator, there are really a lot of them in my func

Re: Cannot find hstore operator

2022-01-23 Thread Paul van der Linden
Thanks for the clarification, but giving up performance is a no-go for us. Also I have my concerns about shemaqualifying each and every use of the -> operator, there are really a lot of them in my functions and it would severely impact readability. Are these the only 2 solutions possible? Paul O