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: <1597422849057-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>
 <572934.1597413823@sss.pgh.pa.us> <1597422849057-0.post@n3.nabble.com>
Comments: In-reply-to PegoraroF10 <marcos@f10.com.br>
	message dated "Fri, 14 Aug 2020 09:34:09 -0700"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <650986.1597427089.1@sss.pgh.pa.us>
Date: Fri, 14 Aug 2020 13:44:49 -0400
Message-ID: <650987.1597427089@sss.pgh.pa.us>
Precedence: bulk

PegoraroF10 <marcos@f10.com.br> writes:
> So, how can I know which custom operator is being used on that comparison ?

You tell us.  I don't know of any common extension that would create
a "smallint = text" operator.  (A variant theory is that you didn't
make a new operator, but an implicit cast from smallint to text.
Either way, it almost certainly is a homebrew thing.  Or maybe what
you are running is not stock Postgres?)

It might be interesting to try some direct test, like

SELECT 22::smallint = 'foo'::text;

For me that gives the same "operator does not exist: smallint = text"
error, but I bet your database tries to execute it.

			regards, tom lane