public inbox for [email protected]  
help / color / mirror / Atom feed
From: Shaozhong SHI <[email protected]>
To: pgsql-sql <[email protected]>
Subject: Recursive query - ERROR: invalid memory alloc request size 1073741824
Date: Sat, 7 May 2022 14:23:53 +0100
Message-ID: <CA+i5JwZ85nr+EBRn4PT9N=V1outgJ7OFBe5VVGoP6bmguC7Bog@mail.gmail.com> (raw)
In-Reply-To: <CA+i5Jwa-8rhDTvg=q+Sox0H7+Gr+NVTO=67=Ch3hQZuZO6TnkQ@mail.gmail.com>
References: <CA+i5Jwa-8rhDTvg=q+Sox0H7+Gr+NVTO=67=Ch3hQZuZO6TnkQ@mail.gmail.com>

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


view thread (4+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Recursive query - ERROR: invalid memory alloc request size 1073741824
  In-Reply-To: <CA+i5JwZ85nr+EBRn4PT9N=V1outgJ7OFBe5VVGoP6bmguC7Bog@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox