Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 9F8002E3683 for ; Sat, 12 Jan 2008 05:02:43 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 59217-02 for ; Sat, 12 Jan 2008 05:02:36 -0400 (AST) Received: from an-out-0708.google.com (an-out-0708.google.com [209.85.132.250]) by postgresql.org (Postfix) with ESMTP id 1CDFF2E31E5 for ; Sat, 12 Jan 2008 05:02:39 -0400 (AST) Received: by an-out-0708.google.com with SMTP id c36so323146ana.33 for ; Sat, 12 Jan 2008 01:02:38 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=GOPTKaY3jQGwn/XPkJBYaFm1UJNOge9ptFo+Vld2a34=; b=d/P+uGp8J0gyYM8oXrDWQ7xKyfBEJzIgoLCj0W09YTw7jrh5Bl7SjT7oHuszTgi4qmBy1qldChsDavW2n+30tB/SMjU+JI/0APejNejOHsq3h5JfQ9I6moxfABBscX1SVhauYq6WmRjeJ4hgu7S8psd59xfNFs+buXfElqi30mg= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=SiWNwHli0NByeYFBDD9LL5hr4MgvbQ+fU9ze1O1CbG/vRzStaNbHdm94s3jtGpMH8/IyNp7ALEWOz+skV6pGCX7uqbce/I/E6e7Ey/MDUuj5cAQvfGSq4EkREWBBApT+Qc3yllqqmWGkKp/Elti1LIa9jIIzR1penT88AAy9e2w= Received: by 10.100.252.16 with SMTP id z16mr8839437anh.89.1200128554060; Sat, 12 Jan 2008 01:02:34 -0800 (PST) Received: by 10.100.44.2 with HTTP; Sat, 12 Jan 2008 01:02:34 -0800 (PST) Message-ID: Date: Sat, 12 Jan 2008 14:32:34 +0530 From: "Rajesh Kumar Mallah" To: "Tom Lane" Subject: Re: (possible) bug with constraint exclusion Cc: pgsql-sql@postgresql.org In-Reply-To: <1442.1200115443@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <23924.1200081368@sss.pgh.pa.us> <1442.1200115443@sss.pgh.pa.us> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/102 X-Sequence-Number: 29955 On Jan 12, 2008 10:54 AM, Tom Lane wrote: > "Rajesh Kumar Mallah" writes: > > Am I correct in understanding that the current behavior is inappropriate > > and shall be corrected at some point of time in future versions ? > > It's a bug, it's patched: > http://archives.postgresql.org/pgsql-committers/2008-01/msg00184.php Thanks for the (unbelievable) quick response, I applied the patch on my production server and the problem is gone. tradein_clients=> \pset null NULL Null display is "NULL". tradein_clients=> SELECT * from temp.x where id is NULL; id ------ NULL (1 row) tradein_clients=> SELECT * from temp.x ; id ------ 1 2 NULL (3 rows) tradein_clients=> Regds mallah. > > regards, tom lane >