Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 1746E9F9F75 for ; Fri, 8 Dec 2006 01:28:17 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 94582-02 for ; Fri, 8 Dec 2006 01:28:08 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from py-out-1112.google.com (py-out-1112.google.com [64.233.166.180]) by postgresql.org (Postfix) with ESMTP id EC86A9F9386 for ; Fri, 8 Dec 2006 01:04:57 -0400 (AST) Received: by py-out-1112.google.com with SMTP id d32so376874pye for ; Thu, 07 Dec 2006 21:04:57 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=U3Dms1xI+0Vuy6N9A6NTIvjnF2xEkZSm7icwzD9ZPIur/DQwq/tb3sZRsXSt/hGUCJbcr33kYZpu3zXF/3Zqgthzp4sFcTX+G+NtOCQ/xr7UxW78D1RBuShL9sToUW22jjv1Ib1c2ShlO8V27fsnZeaGCGati/F9Cb8gwnOVsHc= Received: by 10.35.41.14 with SMTP id t14mr4944061pyj.1165554297090; Thu, 07 Dec 2006 21:04:57 -0800 (PST) Received: by 10.35.80.8 with HTTP; Thu, 7 Dec 2006 21:04:57 -0800 (PST) Message-ID: Date: Fri, 8 Dec 2006 10:34:57 +0530 From: "Rajesh Kumar Mallah" To: "Tom Lane" Subject: Re: Should clients warn in case of server version mismatch ? Cc: "Lista Postgres" In-Reply-To: <25317.1165553807@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <25317.1165553807@sss.pgh.pa.us> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/53 X-Sequence-Number: 23845 On 12/8/06, Tom Lane wrote: > "Rajesh Kumar Mallah" writes: > > 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 ? > > Um, did you read the banner? > > $ ~/version82/bin/psql -p 5581 regression > Welcome to psql 8.2.0 (server 8.1.5), the PostgreSQL interactive terminal. > > Type: \copyright for distribution terms > \h for help with SQL commands > \? for help with psql commands > \g or terminate with semicolon to execute query > \q to quit > > WARNING: You are connected to a server with major version 8.1, > but your psql client is major version 8.2. Some backslash commands, > such as \d, might not work properly. Dear Sir, I am extremely sorry i was just going to apologize for the mistake. But i like the way pg_dump behaves , it refuses to work unless -i is specified. Actually my colleagues complained that \d is not working. I think they got the database prompt as they get everyday and did not notice the warning. ( even i missed to see the WARNING) Warm Regds mallah. > > regression=# > > regards, tom lane >