From: | "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk> |
---|---|
To: | "Zeugswetter Andreas SB SD" <ZeugswetterA(at)spardat(dot)at>, "Hiroshi Inoue" <Inoue(at)tpf(dot)co(dot)jp>, "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:49:15 |
Message-ID: | 03AF4E498C591348A42FC93DEA9661B8259D8D@mail.vale-housing.co.uk |
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]
> Sent: 12 March 2003 09:50
> To: Hiroshi Inoue; Tom Lane
> Cc: Bruce Momjian; pgsql-hackers(at)postgresql(dot)org;
> pgsql-interfaces(at)postgresql(dot)org
> Subject: Re: [HACKERS] Roadmap for FE/BE protocol redesign
>
> > 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.
No, but with them we can avoid cluttering the wire protocol with fields
for all this, and the JDBC required data. With 2 numeric columns
(attrelid, attnum), any application/interface can query the system
catalogs easily for whatever extra info they like.
Regards, Dave.
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2003-03-12 14:55:30 | Re: Roadmap for FE/BE protocol redesign |
Previous Message | Dave Page | 2003-03-12 14:43:22 | Re: Roadmap for FE/BE protocol redesign |
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Cramer | 2003-03-12 14:55:49 | Re: Roadmap for FE/BE protocol redesign |
Previous Message | Hiroshi Inoue | 2003-03-12 14:32:45 | Re: Roadmap for FE/BE protocol redesign |