Message-ID: <3E6E90F7.8757A01F@tpf.co.jp>
Date: Wed, 12 Mar 2003 10:44:23 +0900
From: Hiroshi Inoue <Inoue@tpf.co.jp>
MIME-Version: 1.0
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Bruce Momjian <pgman@candle.pha.pa.us>,
	pgsql-hackers@postgresql.org, pgsql-interfaces@postgresql.org
Subject: Re: Roadmap for FE/BE protocol redesign
References: <200303101915.h2AJF3x20844@candle.pha.pa.us>
	<19245.1047324294@sss.pgh.pa.us> <3E6DB54B.A6B54348@tpf.co.jp>
	<4866.1047393932@sss.pgh.pa.us>
Content-Type: text/plain; charset=iso-2022-jp
Content-Transfer-Encoding: 7bit

Tom Lane wrote:
> 
> Hiroshi Inoue <Inoue@tpf.co.jp> writes:
> > What the driver has suffered from is to get the
> > fields' info of a query result or the parameters'
> > info of a statement. The info is needed even before
> > the execution of the statement(i.e it's only prepared).
> 
> Hm.  Are you saying that you would like PREPARE to send back a
> RowDescription ('T') message?

I'm not sure if PREPARE should return the info directly.
Maybe it should be returned only when it is requested.

> Or is there more to it than that?

More detailed field info is needed anyway.
For example the RowDescription contains neither 
the base column name, the table name nor the
schema name currently and so the current odbc
driver couldn't return the info correctly.
The ODBC function SQLDescribeCol or SQLColAttribute
requires various kind of fields' info.

It's almost impossible to get parameters' info
currently. The ODBC function SQLDescribeParam
isn't implemented yet....

regards,
Hiroshi Inoue
	http://www.geocities.jp/inocchichichi/psqlodbc/