Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] Re: [INTERFACES] retrieving varchar size

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgreSQL(dot)org, pgsql-interfaces(at)postgreSQL(dot)org
Subject: Re: [HACKERS] Re: [INTERFACES] retrieving varchar size
Date: 1998-04-24 14:50:51
Message-ID: 1012.893429451@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-interfaces
Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> writes:
> Added to TODO:
> 	* Add pg_attribute.atttypmod/Resdom->restypmod to PGresult structure
> This is a good suggestion.

This will require a frontend/backend protocol change, no?

If so, right now would be a great time to address it; I'm about halfway
through rewriting libpq for the asynchronous-query support we discussed
last week, and would be happy to make the client-side mods while I still
have the code in my head.

As long as we are opening up the protocol, there is an incredibly grotty
hack in libpq that I'd like to get rid of.  It's hard for me to be
sure whether it's even necessary, but: when libpq gets a 'C' response
(which the documentation says is a "completed response") it assumes that
this is *not* the end of the transaction, and that the only way to be
sure that everything's been read is to send an empty query and wait for
the empty query's 'I' response to be returned.

	case 'C':		/* portal query command, no rows returned */
		/*
		 * since backend may produce more than one result
		 * for some commands need to poll until clear.
		 * Send an empty query down, and keep reading out of
		 * the pipe until an 'I' is received.
		 */

Does this ring a bell with anyone?  I'm prepared to believe that it's
useless code, but have no easy way to be sure.

Needless to say, if there really is an ambiguity then the *right* answer
is to fix the protocol so that the end of a query/response cycle is
unambiguously determinable.  It looks to me like this hack is costing us
an extra round trip to the server for every ordinary query.  That sucks.

			regards, tom lane

Responses

pgsql-hackers by date

Next:From: Bruce MomjianDate: 1998-04-24 15:03:25
Subject: Re: [HACKERS] Profile of current backend
Previous:From: Vazsonyi Peter[ke]Date: 1998-04-24 13:42:08
Subject: create operator problem

pgsql-interfaces by date

Next:From: Jose' Soares Da SilvaDate: 1998-04-24 15:04:55
Subject: Access'97 and ODBC
Previous:From: Patrice HédéDate: 1998-04-24 11:58:34
Subject: Re: ODBC Doc

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group