Date: Tue, 29 Oct 2002 12:12:16 -0800
From: prashanth@jibe.biz
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Bruce Momjian <pgman@candle.pha.pa.us>,
	pgsql-interfaces@postgresql.org
Subject: Re: Non-blocking libpq in 7.3 beta2
Message-ID: <20021029121216.A1027@wind.jibenetworks.com>
References: <200210240432.g9O4WTu18327@candle.pha.pa.us>
	<11476.1035467752@sss.pgh.pa.us>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
User-Agent: Mutt/1.2.5i
In-Reply-To: <11476.1035467752@sss.pgh.pa.us>;
	from tgl@sss.pgh.pa.us on Thu, Oct 24, 2002 at 09:55:52AM -0400


On Thu, Oct 24, 2002 at 09:55:52AM -0400, Tom Lane wrote:
> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > I don't know if you can use 7.3 beta against 7.2.X.
> 
> Should work; AFAIR libpq does not do anything that wouldn't work against
> 7.2 or even older servers.  7.3 psql's \d commands are pretty thoroughly
> broken for older servers, but that shouldn't affect direct use of libpq.
> 
> 			regards, tom lane


I'm having no problems using the 7.3b libpq against a 7.2.1 server, so
far.  

The 7.3 psql is pretty much unusable tho against a 7.2 server.  It
generates a parser error in the server as soon as it starts up and
connects:

DEBUG:  BackendStartup: forked pid=4881 socket=8
postmaster child[4881]: starting with (postgres -d2 -v131072 -p nocprovider )
DEBUG:  InitPostgres
DEBUG:  StartTransactionCommand
DEBUG:  query: select getdatabaseencoding()
DEBUG:  ProcessQuery
DEBUG:  CommitTransactionCommand
DEBUG:  StartTransactionCommand
DEBUG:  query: SELECT usesuper FROM pg_catalog.pg_user WHERE usename = 'prashanth'
ERROR:  parser: parse error at or near "."
DEBUG:  AbortCurrentTransaction

and then goes steadily downhill from there.

thanks,

--prashanth