Postgres Pro
Downloads
Home   >   mailing lists

Re: ERROR: Not enough resources are available to complete this request. - Mailing list pgsql-novice

From Tom Lane
Subject Re: ERROR: Not enough resources are available to complete this request.
Date
Msg-id 11870.1198165626@sss.pgh.pa.us
Whole thread Raw
In response to ERROR: Not enough resources are available to complete this request.  ("Zubkovsky, Sergey" <Sergey.Zubkovsky@transas.com>)
Responses Re: ERROR: Not enough resources are available to complete this request.
List pgsql-novice
Tree view 
"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

pgsql-novice by date:

Previous
From: "Zubkovsky, Sergey"
Date:
Subject: Re: ERROR: Not enough resources are available to complete this request.
Next
From: "Zubkovsky, Sergey"
Date:
Subject: Re: ERROR: Not enough resources are available to complete this request.