From: | "Hiroshi Inoue" <inoue(at)tpf(dot)co(dot)jp> |
---|---|
To: | "'Zeugswetter Andreas SB SD'" <ZeugswetterA(at)spardat(dot)at>, "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | "'Bruce Momjian'" <pgman(at)candle(dot)pha(dot)pa(dot)us>, <pgsql-hackers(at)postgresql(dot)org>, <pgsql-interfaces(at)postgresql(dot)org> |
Subject: | Re: Roadmap for FE/BE protocol redesign |
Date: | 2003-03-12 14:32:45 |
Message-ID: | 000901c2e8a4$40b883f0$0e283ddb@PbgX |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-interfaces |
> -----Original Message-----
> From: Zeugswetter Andreas SB SD [mailto:ZeugswetterA(at)spardat(dot)at]
>
> Hiroshi Inoue wrote:
> > Tom Lane wrote:
> > >
> > > Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)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.
>
> 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
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2003-03-12 14:43:22 | Re: Roadmap for FE/BE protocol redesign |
Previous Message | mlw | 2003-03-12 14:03:26 | Case insensitivity, and option? |
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2003-03-12 14:49:15 | Re: Roadmap for FE/BE protocol redesign |
Previous Message | Rodrigo Moya | 2003-03-12 12:51:44 | Re: Automatic detection of PostgreSQL version |