From: Gergely Czuczy <phoemix@harmless.hu>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-interfaces <pgsql-interfaces@postgresql.org>
Subject: Re: libpq PQexecPrepared returns NULL
Date: Thu, 4 Mar 2004 16:03:52 +0100 (CET)
Message-ID: <Pine.LNX.4.44.0403041602100.69-100000@localhost> (raw)
In-Reply-To: <25614.1078412346@sss.pgh.pa.us>
hello
the strange thing is -- what i've forgot to mention -- is that
PQerrorMessage returns an empty string, so from this i don't know the
source of the error.
how can I check if it is _really_ out of memory?
i have 1G RAM in the box, and shm values are set:
kernel.shmmax = 536870912
kernel.shmall = 536870912
Bye,
Gergely Czuczy
mailto: phoemix@harmless.hu
PGP: http://phoemix.harmless.hu/phoemix.pgp
The point is, that geeks are not necessarily the outcasts
society often believes they are. The fact is that society
isn't cool enough to be included in our activities.
On Thu, 4 Mar 2004, Tom Lane wrote:
> Gergely Czuczy <phoemix@harmless.hu> writes:
> > i've got a very strange problem, PQexecPrepared returns NULL, but if i
> > immadietly rerun the query it will run normally, returning the query
> > result. what can be the problem, and how could I track it down, solve it?
>
> Check PQerrorMessage().
>
> AFAIR the only reasons for a null result (instead of a possibly-error
> PGresult) would be out-of-memory or connection failure.
>
> regards, tom lane
>
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: pgsql-interfaces@postgresql.org
Cc: phoemix@harmless.hu, tgl@sss.pgh.pa.us
Subject: Re: libpq PQexecPrepared returns NULL
In-Reply-To: <Pine.LNX.4.44.0403041602100.69-100000@localhost>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox