Horton

Re: Server goes to Recovery Mode when run a SQL

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: PegoraroF10 <marcos@f10.com.br>
Cc: pgsql-general@postgresql.org
Date: 2020-08-14T14:03:43Z
Lists: 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

Commits

  1. Be more careful about the shape of hashable subplan clauses.