Re: ERROR: Not enough resources are available to complete this request.

["Zubkovsky, Sergey" <Sergey(dot)Zubkovsky(at)transas(dot)com>]

Yes, it's my negligence!

Thank you, Tom!


-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us] 
Sent: Thursday, December 20, 2007 6:47 PM
To: Zubkovsky, Sergey
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: [NOVICE] ERROR: Not enough resources are available to
complete this request.

"Zubkovsky, Sergey" <Sergey(dot)Zubkovsky(at)transas(dot)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