Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id D8BAC9FA0B7 for ; Fri, 8 Dec 2006 03:11:52 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024) with ESMTP id 86432-08 for ; Fri, 8 Dec 2006 03:11:35 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from ns1.peker.com.pl (181-ego-2.acn.waw.pl [62.121.85.181]) by postgresql.org (Postfix) with SMTP id D8DFF9F9C35 for ; Fri, 8 Dec 2006 03:11:46 -0400 (AST) Received: (qmail 18262 invoked by uid 540); 8 Dec 2006 07:02:29 -0000 Received: from 153.19.179.26 by ns1.peker.com.pl (envelope-from , uid 401) with qmail-scanner-1.25st (clamdscan: 0.82/760. spamassassin: 3.0.2. perlscan: 1.25st. Clear:RC:0(153.19.179.26):SA:0(-2.6/8.0):. Processed in 3.658046 secs); 08 Dec 2006 07:02:29 -0000 Received: from rzgw.artnet.pl (HELO ?10.4.128.107?) (informatyka-adamr@153.19.179.26) by ns1.peker.com.pl with SMTP; 8 Dec 2006 07:02:25 -0000 Message-ID: <45790F91.4090404@informatyka.gdansk.pl> Date: Fri, 08 Dec 2006 08:09:05 +0100 From: Adam Radlowski User-Agent: Mozilla Thunderbird 1.0.6 (X11/20050716) X-Accept-Language: pl, en-us, en MIME-Version: 1.0 To: Rajesh Kumar Mallah CC: Lista Postgres Subject: Re: Should clients warn in case of server version mismatch References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-2; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/55 X-Sequence-Number: 23847 I had problem such this. I've got 8.1.3 client and 8.0.6 server. But psql 8.1.3 warned me, that some \? functions can not work properly. I've resolved this problem in very simply way. I got binary psql from 8.0.x and run. Psql program is a client program, that uses libpq library, so it is (I think) no difference until the libpq includes correct and enough routines to call them from psql. I've tested for example my own application compiled with 8.1.3 libpq on 7.4.8 libpq, or compiled with 8.0.7 on 8.1.3. But the not use functions, like \?. No problems. But the \? functions in psql are implemented (I think) in other way and are version specific, becouse the consttruction of information part of database is not compatible between versions 8.0.x and 8.1.x and 8.2.x (the first two numbers of a version are signifficant in this case). Brgds Adam Rajesh Kumar Mallah wrote: > Hi, > > We connected psql 8.2.0 accidently to postmaster ver 8.1.5. > \d tablename does not work. > > should psql at least warn like pg_dump does in case > of such client server version mismatches ? > > regds > mallah. > > ---------------------------(end of broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match > >