X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id ACF6BD1CA5F for ; Thu, 4 Mar 2004 14:59:08 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 63416-10 for ; Thu, 4 Mar 2004 10:59:08 -0400 (AST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id 27301D1C94B for ; Thu, 4 Mar 2004 10:59:05 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i24Ex78a025615; Thu, 4 Mar 2004 09:59:07 -0500 (EST) To: Gergely Czuczy Cc: pgsql-interfaces Subject: Re: libpq PQexecPrepared returns NULL In-reply-to: References: Comments: In-reply-to Gergely Czuczy message dated "Thu, 04 Mar 2004 13:07:00 +0100" Date: Thu, 04 Mar 2004 09:59:06 -0500 Message-ID: <25614.1078412346@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/5 X-Sequence-Number: 4784 Gergely Czuczy 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