Date: Wed, 20 Aug 2003 23:11:10 -0700 (PDT)
From: Stephan Szabo <sszabo@megazone.bigpanda.com>
To: Anagha Joshi <ajoshi@nulinkinc.com>
Cc: <pgsql-hackers-owner@postgresql.org>,
	<pgsql-admin@postgresql.org>, <pgsql-sql@postgresql.org>
Subject: Re: URGENT : free result (libpq++ API)
In-Reply-To: <FF851C7EEB75954F9BCFB5CA117AB1EC09289E@delta.nulinkinc.com>
Message-ID: <20030820230649.P33044-100000@megazone.bigpanda.com>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII


On Thu, 21 Aug 2003, Anagha Joshi wrote:

> Hi all,
> I'm using PG - 7.2.4 on Solaries.
> I'm using "libpq++" library as client implementation is coded in "C++".
>
> I'm doing the following :
> 1.	Making the connection to database by creating new object of
> "PgDatabase" i.e.
> data = new PgDatabase( " CONNECTION INFO ");
>
> 2.	Then I execure the query with:
> int return = data->Exec( " THIS IS A SQL QUERY");
>
> My question is ,
> How should I clear(free) the result of the query? Need  I close the
> connection after each query to do that?

It looks to me that PgConnection::Exec clears an existing query result
when it's called.

// PgConnection::exec  -- send a query to the backend
ExecStatusType PgConnection::Exec(const char* query)
{
	// Clear the result stucture if needed
	if (pgResult)
		PQclear(pgResult);

	// Execute the given query
	pgResult = PQexec(pgConn, query);

	// Return the status
	if (pgResult)
		return PQresultStatus(pgResult);
	else
		return PGRES_FATAL_ERROR;
}