libpq Describe Extension [WAS: Bytea and perl] - Mailing list pgsql-hackers

From Volkan YAZICI
Subject libpq Describe Extension [WAS: Bytea and perl]
Date
Msg-id 20060401183944.GA183@alamut
Whole thread Raw
Responses Re: libpq Describe Extension [WAS: Bytea and perl]  (Volkan YAZICI <yazicivo@ttnet.net.tr>)
List pgsql-hackers
Hi,

On Mar 25 08:47, John DeSoi wrote:
> I have not looked at libpq in any detail, but it should have access
> to the type of all the parameters in the prepared statement. The
> Describe (F) statement in the frontend/backend protocol identifies
> the type of each parameter.

I've prepared a patch for the Describe <-> ParameterDescription
messaging which is available via current extended query protocol.

Usage (and implementation) is explained in the patch's documentation
related part. (Also I tried to place informative comments in the code
too.)

But I've a problem with ereport() error calls caused by erronous
target_type entries. After an error in exec_describe_statement_message()
(or exec_describe_portal_message()) it leaves block with ereport() call
and client side stalls in PGASYNC_BUSY state while backend stalls in
PostgresMain() by calling ReadCommand(). To summerize, an error
returning pqDescribe() call causes both side to stall.

I'd be so appreciated to hear your thoughts about the patch and above
problem.


Regards.

Attachment

pgsql-hackers by date:

Previous
From: Agent M
Date:
Subject: Re: control pg_hba.conf via SQL
Next
From: "Gustavo Tonini"
Date:
Subject: Re: Slony-I for circular replication