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

[Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>]

"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