Message-ID: <656d2904a36c478327d991e9c69dd1ae81853133.camel@cybertec.at>
Subject: Re: ERROR: stack depth limit exceeded
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: csanyipal@gmail.com
Cc: general pgsql <pgsql-general@lists.postgresql.org>
Date: Thu, 20 Feb 2025 10:33:38 +0100
In-Reply-To: <CAONhAovH30MLh+KCGxjuZW+YSoVTGrHLjGpa31OqM72Rq0HYvg@mail.gmail.com>
References: 
	<CAONhAovOas_XLigiebcfL5_q9M2iCHwG5hkYQk0L0qh_8RoQEw@mail.gmail.com>
	 <2b9a5afa4abfcdbab0a585c1a77279dc90a60a83.camel@cybertec.at>
	 <CAONhAovH30MLh+KCGxjuZW+YSoVTGrHLjGpa31OqM72Rq0HYvg@mail.gmail.com>
User-Agent: Evolution 3.54.3 (3.54.3-1.fc41) 
MIME-Version: 1.0
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Archived-At: <https://www.postgresql.org/message-id/656d2904a36c478327d991e9c69dd1ae81853133.camel%40cybertec.at>
Precedence: bulk

On Wed, 2025-02-19 at 16:49 +0100, Cs=C3=A1nyi P=C3=A1l wrote:
> the trigger function definition is like:
> [...]
> INSERT INTO
> =C2=A0=C2=A0=C2=A0 HAVONKENTI_MEGTAKARITASAINK (EZEN_IDOKOZBEN, MEGTAKARI=
TVA_RSD, KELT)
> [...]
>=20
> and the trigger definition is like:
> CREATE OR REPLACE TRIGGER uj_nyugdij_beirasakor_kiold
> =C2=A0=C2=A0=C2=A0 AFTER INSERT
> =C2=A0=C2=A0=C2=A0 ON public.javaink_forgalma
> =C2=A0=C2=A0=C2=A0 FOR EACH ROW
> =C2=A0=C2=A0=C2=A0 EXECUTE FUNCTION public.ket_nyugdij_kozotti_megtakarit=
asaink();

That does not look circular right away, but perhaps there is
a trigger on HAVONKENTI_MEGTAKARITASAINK, or perhaps there is
some other trigger on javaink_forgalma.

It must be something of that kind.

Yours,
Laurenz Albe

--=20

*E-Mail Disclaimer*
Der Inhalt dieser E-Mail ist ausschliesslich fuer den=20
bezeichneten Adressaten bestimmt. Wenn Sie nicht der vorgesehene Adressat=
=20
dieser E-Mail oder dessen Vertreter sein sollten, so beachten Sie bitte,=20
dass jede Form der Kenntnisnahme, Veroeffentlichung, Vervielfaeltigung oder=
=20
Weitergabe des Inhalts dieser E-Mail unzulaessig ist. Wir bitten Sie, sich=
=20
in diesem Fall mit dem Absender der E-Mail in Verbindung zu setzen.

*CONFIDENTIALITY NOTICE & DISCLAIMER
*This message and any attachment are=20
confidential and may be privileged or otherwise protected from disclosure=
=20
and solely for the use of the person(s) or entity to whom it is intended.=
=20
If you have received this message in error and are not the intended=20
recipient, please notify the sender immediately and delete this message and=
=20
any attachment from your system. If you are not the intended recipient, be=
=20
advised that any use of this message is prohibited and may be unlawful, and=
=20
you must not copy this message or attachment or disclose the contents to=20
any other person.