X-Original-To: pgsql-hackers@postgresql.org Received: from net2.micro-automation.com (net2.micro-automation.com [64.7.141.29]) by postgresql.org (Postfix) with SMTP id 531C74758E6 for ; Wed, 12 Mar 2003 09:55:48 -0500 (EST) Received: (qmail 2796 invoked from network); 12 Mar 2003 14:55:49 -0000 Received: from eboxwest.ebox.com (HELO ?192.168.1.32?) (206.51.23.194) by net2.micro-automation.com with SMTP; 12 Mar 2003 14:55:49 -0000 Subject: Re: Roadmap for FE/BE protocol redesign From: Dave Cramer Cc: "pgsql-hackers@postgresql.org" , "pgsql-interfaces@postgresql.org" In-Reply-To: <03AF4E498C591348A42FC93DEA9661B8259D8D@mail.vale-housing.co.uk> References: <03AF4E498C591348A42FC93DEA9661B8259D8D@mail.vale-housing.co.uk> Content-Type: text/plain Organization: Cramer Consulting Message-Id: <1047480948.1045.16.camel@inspiron.cramers> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.2.1 Date: 12 Mar 2003 09:55:49 -0500 Content-Transfer-Encoding: 7bit X-AntiVirus: scanned for viruses by AMaViS 0.2.1 (http://amavis.org/) X-Archive-Number: 200303/479 X-Sequence-Number: 36725 This may be problematic in the future if we change attrelid, attnum. My preference would be to be able to query the backend for the information if I need it. It is rarely required. ie give me the meta data for the last resultset. Dave On Wed, 2003-03-12 at 09:49, Dave Page wrote: > > -----Original Message----- > > From: Zeugswetter Andreas SB SD [mailto:ZeugswetterA@spardat.at] > > Sent: 12 March 2003 09:50 > > To: Hiroshi Inoue; Tom Lane > > Cc: Bruce Momjian; pgsql-hackers@postgresql.org; > > pgsql-interfaces@postgresql.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. -- Dave Cramer -- Dave Cramer Cramer Consulting