From: Tom Lane <tgl@sss.pgh.pa.us>
To: PegoraroF10 <marcos@f10.com.br>
cc: pgsql-general@postgresql.org
Subject: Re: Server goes to Recovery Mode when run a SQL
In-reply-to: <1597410304614-0.post@n3.nabble.com>
References: <1549209182255-0.post@n3.nabble.com>
 <37bc715f-12e2-84ac-6492-88d7b6306777@aklaver.com>
 <1549211574297-0.post@n3.nabble.com>
 <cfcb3858-d169-652c-71a7-5d77f295085a@aklaver.com>
 <20190204010709.GC1881@paquier.xyz> <1597265258319-0.post@n3.nabble.com>
 <323345.1597270142@sss.pgh.pa.us> <1597410304614-0.post@n3.nabble.com>
Comments: In-reply-to PegoraroF10 <marcos@f10.com.br>
	message dated "Fri, 14 Aug 2020 06:05:04 -0700"
MIME-Version: 1.0
Content-Type: text/plain; charset="UTF-8"
Content-ID: <572933.1597413823.1@sss.pgh.pa.us>
Content-Transfer-Encoding: quoted-printable
Date: Fri, 14 Aug 2020 10:03:43 -0400
Message-ID: <572934.1597413823@sss.pgh.pa.us>
Precedence: bulk

PegoraroF10 <marcos@f10.com.br> writes:
> This is the way you can test to push your server immediatelly to recover=
y
> mode. This one you=C2=B4ll 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 =3D text
LINE 2: ...eber_ID) filter (where ((status <> 6) or (TipoRecebimento in
                                                                     ^
HINT:  No operator matches the given name and argument types. You might ne=
ed to add explicit type casts.

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

			regards, tom lane