Super, thank you so much for the tip.
I still have a little problem where I don't get far ;-)
I constantly get an error message when I give the SET a value.
Siehe unten.
ERROR: ERROR: invalid value for parameter "idle_in_transaction_session_timeout": "_timeout" CONTEXT: SQL statement "SET
idle_in_transaction_session_timeoutTO _timeout" PL/pgSQL function set_transfer(integer,character varying,character
varying)Line 4 at SET SQL state: 22023SELECT * FROM
Call function:
set_transfer(87,'users','5000');
Function:
CREATE OR REPLACE FUNCTION public.set_transfer(_id integer, _tablename character varying, _timeout character varying)
RETURNS SETOF users
LANGUAGE 'plpgsql'AS $BODY$
BEGIN
SET idle_in_transaction_session_timeout TO _timeout;
......
END
I've tried almost everything. :-(
Best Regards
Jakob
-----Ursprüngliche Nachricht-----
Von: Peter Eisentraut [mailto:peter.eisentraut@2ndquadrant.com]
Gesendet: Dienstag, 24. September 2019 09:05
An: Witczak, Jakob; jonathan.katz@excoventures.com
Cc: pgsql-sql@postgresql.org
Betreff: Re: AW: German "umlaut insensitive" query
On 2019-09-23 07:57, Jakob.Witczak@dlr.de wrote:
> Thanks for the quick answer. I am looking forward to the new PostgresSQL
> version. Thanks
In the meantime, the unaccent contrib module can also help.
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services