I'm certainly not trying to be difficult, I just don't know a lot about the internals of PostgreSQL. I'm developing some interfaces to various databases and certainly wanted to include PostgreSQL.
>From my less-than-qualified viewpoint, I would have thought including the base table name and bit pattern indicating certain features (nullability, primary index, etc) for each column in the RowDescriptor message would have been the best. Since my driver will need to support current and previous versions of PostgreSQL, my plan is to write some code to parse a SQL statement and extract the table names. (ugh!) One approach might be to add the tables's oid to the RowDescriptor message. Would not be perfect since I still would have many roundtrips to the database to get metadata, but since I don't need metadata in every case I can leave that step out until someone requests it. Reggie > -----Original Message----- > From: Neil Conway [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, January 28, 2003 11:47 PM > To: Reggie Burnett > Cc: 'Tom Lane'; 'Dave Cramer'; 'PostgreSQL Hackers Mailing List' > Subject: Re: [HACKERS] Request for qualified column names > > On Mon, 2003-01-27 at 10:44, Reggie Burnett wrote: > > Well, certainly the driver could parse the sql and extract what it > > thinks is the table name. It just seems quite foreign to me to have a > > database engine go through the motions of determining column location > > and have ready access to all the metadata for all the columns in a > > resultset and then intentionally leave all that out of the FE/BE. > > I think the issue is that no one has yet proposed a consistent set of > behaviour for this feature, particularly in the cases that Tom raised. > If you would like this feature, I'd suggest that you outline some > behaviour that everyone can agree upon. > > Griping about "intentionally left out" features when the feature itself > is not even well defined doesn't strike me as very productive. > > Cheers, > > Neil > -- > Neil Conway <[EMAIL PROTECTED]> || PGP Key ID: DB3C29FC > > ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly