MIME-Version: 1.0
Reply-To: csanyipal@gmail.com
From: =?UTF-8?B?Q3PDoW55aSBQw6Fs?= <csanyipal@gmail.com>
Date: Wed, 19 Feb 2025 11:23:18 +0100
Message-ID: <CAONhAovOas_XLigiebcfL5_q9M2iCHwG5hkYQk0L0qh_8RoQEw@mail.gmail.com>
Subject: ERROR: stack depth limit exceeded
To: general pgsql <pgsql-general@lists.postgresql.org>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Archived-At: <https://www.postgresql.org/message-id/CAONhAovOas_XLigiebcfL5_q9M2iCHwG5hkYQk0L0qh_8RoQEw%40mail.gmail.com>
Precedence: bulk

Hi,

I am running postgresql 15 on Debian 12 operating system.
I also installed PgAdmin4 and am using the desktop version of it.
I have created a trigger function and a trigger which will run the
following code, see below.
Before this trigger would run, I tried this code.
When running the code I get the following error message:
ERROR: stack depth limit exceeded HINT: Increase the configuration
parameter "max_stack_depth" (currently 2048kB), after ensuring the
platform's stack depth limit is adequate.

Where am I making a mistake, and what can I do to make this code and
this trigger run successfully?

-- Insert the RSD saved between my last two pensions in the
haavi_megtakaritasaink table.
-- INSERT INTO x(a) VALUES (tsrange($1, $2, '[)'));
-- Includes the first date [, the second date is not ).
INSERT INTO
    vagyonunk_kezelese.public.havonkenti_megtakaritasaink
(ezen_idokozben, megtakaritva_rsd, kelt)
VALUES ((select tsrange((
        SELECT
            kelt
        FROM
            javaink_forgalma
        WHERE
            EN_KAPTAM =3D 'true'
            AND AZ_ARU_NEVE =3D 'nyugd=C3=ADjam'
        ORDER BY
            KELT DESC
        LIMIT
            1
        OFFSET
            1
    ),(
        SELECT
            KELT
        FROM
            JAVAINK_FORGALMA
        WHERE
            EN_KAPTAM =3D 'true'
            AND AZ_ARU_NEVE =3D 'nyugd=C3=ADjam'
        ORDER BY
            KELT DESC
        LIMIT
            1
        OFFSET
            0
    ),'[)')),(SELECT
    SUM(EGYSEGAR * ENNYI_EGYSEG)
FROM
    JAVAINK_FORGALMA
WHERE
    A_PENZNEM =3D 'RSD'
    AND KELT >=3D (
        SELECT
            KELT
        FROM
            JAVAINK_FORGALMA
        WHERE
            EN_KAPTAM =3D 'true'
            AND AZ_ARU_NEVE =3D 'nyugd=C3=ADjam'
        ORDER BY
            KELT DESC
        LIMIT
            1
        OFFSET
            1
    )
    AND KELT < (
        SELECT
            KELT
        FROM
            JAVAINK_FORGALMA
        WHERE
            EN_KAPTAM =3D 'true'
            AND AZ_ARU_NEVE =3D 'nyugd=C3=ADjam'
        ORDER BY
            KELT DESC
        LIMIT
            1
        OFFSET
            0
    )), DEFAULT)
;

Thanks for all the advice!

--
Best wishes by Paul Chanyi!