X-Original-To: pgsql-hackers@postgresql.org Received: from sd.tpf.co.jp (sd.tpf.co.jp [210.161.239.34]) by postgresql.org (Postfix) with SMTP id A735D475EB2 for ; Wed, 12 Mar 2003 09:32:56 -0500 (EST) Received: (qmail 16372 invoked from network); 12 Mar 2003 14:32:53 -0000 X-Authentication: inoue was authenticated by sd.tpf.co.jp at 12 Mar 2003 14:32:53 -0000 Received: from unknown (HELO PbgX) (219.61.40.14) by sd.tpf.co.jp with SMTP; 12 Mar 2003 14:32:53 -0000 From: "Hiroshi Inoue" To: "'Zeugswetter Andreas SB SD'" , "'Tom Lane'" Cc: "'Bruce Momjian'" , , Subject: Re: Roadmap for FE/BE protocol redesign Date: Wed, 12 Mar 2003 23:32:45 +0900 Message-ID: <000901c2e8a4$40b883f0$0e283ddb@PbgX> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.3416 In-Reply-To: <46C15C39FEB2C44BA555E356FBCD6FA4961F5A@m0114.s-mxs.net> Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Archive-Number: 200303/474 X-Sequence-Number: 36720 > -----Original Message----- > From: Zeugswetter Andreas SB SD [mailto:ZeugswetterA@spardat.at] > > Hiroshi Inoue wrote: > > Tom Lane wrote: > > > > > > Hiroshi Inoue 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. > > But it only needs that info to do system catalog lookups for > type, length etc. > Imho the target should be to not need catalog lookups, but > get all needed info > from the 'T' message, no? Maybe. > > > The ODBC function SQLDescribeCol or SQLColAttribute > > requires various kind of fields' info. > > RETCODE SQL_API SQLDescribeCol( > HSTMT hstmt, > UWORD icol, > UCHAR FAR *szColName, > SWORD cbColNameMax, > SWORD FAR *pcbColName, > SWORD FAR *pfSqlType, > UDWORD FAR *pcbColDef, > SWORD FAR *pibScale, > SWORD FAR *pfNullable); > > So you see it does not need tablename or schema. Oh yes but SQLColAtrribute should return such info if requested. regards, Hiroshi Inoue