Horton

Re: Server goes to Recovery Mode when run a SQL

Marcos Pegoraro <marcos@f10.com.br>

View thread View on postgr.es
From: PegoraroF10 <marcos@f10.com.br>
To: pgsql-general@postgresql.org
Date: 2020-08-14T18:33:21Z
Lists: pgsql-general 
It works, shouldn´t but works. Results False

And I have created these two operators a long time ago. 

CREATE OPERATOR public.= (
    FUNCTION = public.fntextonumero,
    LEFTARG = text,
    RIGHTARG = public.i32
);
CREATE OPERATOR public.= (
    FUNCTION = public.fntextonumero,
    LEFTARG = public.i32,
    RIGHTARG = text
);

Droped them and works as expected, giving me same message like yours.

DROP OPERATOR public.= (text,public.i32);
DROP OPERATOR public.= (public.i32,text);




--
Sent from: https://www.postgresql-archive.org/PostgreSQL-general-f1843780.html

Commits

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