X-Git-Url: https://git.openstreetmap.org./rails.git/blobdiff_plain/9508368d37fe6e9d54a2d51ed8d886261ec4a9e9..816ee8ec92735b5c80b382857953ac4325096a71:/db/structure.sql diff --git a/db/structure.sql b/db/structure.sql index dce83214d..6370eb95a 100644 --- a/db/structure.sql +++ b/db/structure.sql @@ -1,6 +1,5 @@ SET statement_timeout = 0; SET lock_timeout = 0; -SET idle_in_transaction_session_timeout = 0; SET client_encoding = 'UTF8'; SET standard_conforming_strings = on; SELECT pg_catalog.set_config('search_path', '', false); @@ -185,6 +184,30 @@ END; $$; +-- +-- Name: xid_to_int4(xid); Type: FUNCTION; Schema: public; Owner: - +-- + +CREATE FUNCTION public.xid_to_int4(t xid) RETURNS integer + LANGUAGE plpgsql STRICT + AS $$ +DECLARE + tl bigint; + ti int; +BEGIN + tl := t; + + IF tl >= 2147483648 THEN + tl := tl - 4294967296; + END IF; + + ti := tl; + + RETURN ti; +END; +$$; + + SET default_tablespace = ''; SET default_with_oids = false;