Re: Server goes to Recovery Mode when run a SQL - Mailing list pgsql-general

From Tom Lane
Subject Re: Server goes to Recovery Mode when run a SQL
Date
Msg-id 572934.1597413823@sss.pgh.pa.us
Whole thread Raw
In response to Re: Server goes to Recovery Mode when run a SQL  (PegoraroF10 <marcos@f10.com.br>)
Responses Re: Server goes to Recovery Mode when run a SQL  (PegoraroF10 <marcos@f10.com.br>)
Re: Server goes to Recovery Mode when run a SQL  (PegoraroF10 <marcos@f10.com.br>)
List pgsql-general
PegoraroF10 <marcos@f10.com.br> writes:
> This is the way you can test to push your server immediatelly to recovery
> mode. This one you´ll get the problem instantaneously, differently from the
> last one which you have to wait a long time to happen.

When I try this I get

ERROR:  operator does not exist: smallint = text
LINE 2: ...eber_ID) filter (where ((status <> 6) or (TipoRecebimento in
                                                                     ^
HINT:  No operator matches the given name and argument types. You might need to add explicit type casts.

which makes me wonder whether you've got a buggy custom operator.

            regards, tom lane



pgsql-general by date:

Previous
From: Anass El Bouanani
Date:
Subject: Postgres Clusterisation best choice ?
Next
From: Rene Romero Benavides
Date:
Subject: Re: PostgreSQL 10.12. background writer not cleaning buffers, small working set, big shared_buffers