pg.ddx.io  pgsql-general@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: PegoraroF10 <marcos@f10.com.br>
To: pgsql-general@postgresql.org
Subject: Re: Server goes to Recovery Mode when run a SQL
Date: Fri, 14 Aug 2020 12:17:44 -0700 (MST)
Message-ID: <1597432664458-0.post@n3.nabble.com> (raw)
In-Reply-To: <654057.1597431203@sss.pgh.pa.us>
References: <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>
	<650987.1597427089@sss.pgh.pa.us>
	<1597430001991-0.post@n3.nabble.com>
	<654057.1597431203@sss.pgh.pa.us>

Well, I didn´t know where was the problem exactly, then ...
The entire script to see that problem is 

create domain public.i32 as integer;

CREATE FUNCTION public.fntextonumero(ftext text, finteger public.i32)
RETURNS boolean
    LANGUAGE sql STABLE
    AS $$
  SELECT ftext = finteger::text;
$$;
CREATE FUNCTION public.fntextonumero(finteger public.i32, ftext text)
RETURNS boolean
    LANGUAGE sql STABLE
    AS $$
  SELECT ftext = finteger::text;
$$;

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

Then that script I´ve sent you this morning.
This way I think you can get the problem. Is this a Postgres problem ? Well,
I created these operators because Firebird accepts comparisons between
numeric and text values, and as we converted from that ... I found a way to
continue comparing them. The problem ocurred now because the IN operator. 



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





view thread (36+ messages)  latest in thread

Message-ID: <1597432664458-0.post@n3.nabble.com>
Permalink:  ../1597432664458-0.post@n3.nabble.com/
Also on:    postgresql.org/message-id/1597432664458-0.post@n3.nabble.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-general@postgresql.org
  Cc: marcos@f10.com.br
  Subject: Re: Server goes to Recovery Mode when run a SQL
  In-Reply-To: <1597432664458-0.post@n3.nabble.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox