Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1k6ebz-0008Cb-Bl for pgsql-general@arkaria.postgresql.org; Fri, 14 Aug 2020 18:39:31 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1k6eby-00053v-6b for pgsql-general@arkaria.postgresql.org; Fri, 14 Aug 2020 18:39:30 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1k6eW9-0004pE-4T for pgsql-general@lists.postgresql.org; Fri, 14 Aug 2020 18:33:29 +0000 Received: from n3.nabble.com ([162.255.23.22]) by magus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1k6eW5-0005Mp-63 for pgsql-general@postgresql.org; Fri, 14 Aug 2020 18:33:28 +0000 Received: from n3.nabble.com (localhost [127.0.0.1]) by n3.nabble.com (Postfix) with ESMTP id F28DA205D491B for ; Fri, 14 Aug 2020 11:33:21 -0700 (MST) Date: Fri, 14 Aug 2020 11:33:21 -0700 (MST) From: PegoraroF10 To: pgsql-general@postgresql.org Message-ID: <1597430001991-0.post@n3.nabble.com> In-Reply-To: <650987.1597427089@sss.pgh.pa.us> References: <37bc715f-12e2-84ac-6492-88d7b6306777@aklaver.com> <1549211574297-0.post@n3.nabble.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> <650987.1597427089@sss.pgh.pa.us> Subject: Re: Server goes to Recovery Mode when run a SQL MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk It works, shouldn=C2=B4t but works. Results False And I have created these two operators a long time ago.=20 CREATE OPERATOR public.=3D ( FUNCTION =3D public.fntextonumero, LEFTARG =3D text, RIGHTARG =3D public.i32 ); CREATE OPERATOR public.=3D ( FUNCTION =3D public.fntextonumero, LEFTARG =3D public.i32, RIGHTARG =3D text ); Droped them and works as expected, giving me same message like yours. DROP OPERATOR public.=3D (text,public.i32); DROP OPERATOR public.=3D (public.i32,text); -- Sent from: https://www.postgresql-archive.org/PostgreSQL-general-f1843780.h= tml