MIME-Version: 1.0
References: 
 <CA+i5Jwa-8rhDTvg=q+Sox0H7+Gr+NVTO=67=Ch3hQZuZO6TnkQ@mail.gmail.com>
In-Reply-To: 
 <CA+i5Jwa-8rhDTvg=q+Sox0H7+Gr+NVTO=67=Ch3hQZuZO6TnkQ@mail.gmail.com>
From: Shaozhong SHI <shishaozhong@gmail.com>
Date: Sat, 7 May 2022 14:23:53 +0100
Message-ID: 
 <CA+i5JwZ85nr+EBRn4PT9N=V1outgJ7OFBe5VVGoP6bmguC7Bog@mail.gmail.com>
Subject: Recursive query - ERROR: invalid memory alloc request size 1073741824
To: pgsql-sql <pgsql-sql@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000937c7105de6be367"
Archived-At: 
 <https://www.postgresql.org/message-id/CA%2Bi5JwZ85nr%2BEBRn4PT9N%3DV1outgJ7OFBe5VVGoP6bmguC7Bog%40mail.gmail.com>
Precedence: bulk

--000000000000937c7105de6be367
Content-Type: text/plain; charset="UTF-8"

There is a loop of recursive query.  It runs at a point where it stops.

This error turned up.- ERROR:  invalid memory alloc request size 1073741824

Can anyone provide pointers how to solve this problem or work around?

Regards,

David

--000000000000937c7105de6be367
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail=
_attr">There is a loop of recursive query.=C2=A0 It runs at a point where i=
t stops.<br></div><div dir=3D"ltr"><div dir=3D"ltr"><div><br></div><div>Thi=
s error turned up.-=C2=A0ERROR:=C2=A0 invalid memory alloc request size 107=
3741824</div><div><br></div><div>Can anyone provide pointers how to solve t=
his problem or work around?</div><div><br></div><div>Regards,</div><div><br=
></div><div>David</div></div></div>
</div></div>

--000000000000937c7105de6be367--