Yes, it's my negligence!
Thank you, Tom!
-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Thursday, December 20, 2007 6:47 PM
To: Zubkovsky, Sergey
Cc: pgsql-novice@postgresql.org
Subject: Re: [NOVICE] ERROR: Not enough resources are available to
complete this request.
"Zubkovsky, Sergey" <Sergey.Zubkovsky@transas.com> writes:
> I'm trying to call my PL/pgSQL stored procedure and receive the
> following error message:
> ERROR: Not enough resources are available to complete this request.
> SQL state: P0001
> How can I determine what kind of resource is unavailable or what is
> wrong?
You tell us. P0001 is RAISE_EXCEPTION, meaning that this message is
coming from a RAISE EXCEPTION command in your own plpgsql code.
regards, tom lane