Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id D4D752E0052 for ; Thu, 17 Apr 2008 09:14:52 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 07868-09 for ; Thu, 17 Apr 2008 09:14:48 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from secure.socket.ch (secure.socket.ch [212.103.70.36]) by developer.postgresql.org (Postfix) with ESMTP id D50222E0044 for ; Thu, 17 Apr 2008 09:14:48 -0300 (ADT) Received: from [194.153.94.2] (helo=[192.168.1.39]) by secure.socket.ch with esmtpsa (TLSv1:AES128-SHA:128) (Exim 4.69 (FreeBSD)) (envelope-from ) id 1JmT0j-000E9d-77; Thu, 17 Apr 2008 14:14:46 +0200 Cc: "pgsql-performance@postgresql.org" Message-Id: From: Thomas Spreng To: sathiya psql In-Reply-To: Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes Content-Transfer-Encoding: 7bit Mime-Version: 1.0 (Apple Message framework v919.2) Subject: Re: rename constraint Date: Thu, 17 Apr 2008 14:14:38 +0200 References: X-Mailer: Apple Mail (2.919.2) X-SA-Exim-Connect-IP: 194.153.94.2 X-SA-Exim-Mail-From: spreng@socket.ch X-SA-Exim-Scanned: No (on secure.socket.ch); SAEximRunCond expanded to false X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200804/235 X-Sequence-Number: 29728 On 17.04.2008, at 14:03, sathiya psql wrote: > Hi, > > I need to change the name of the constraint., > > Or i need to drop the constraint, and i need to create constraint > with new > name, how the impact of this in performance, because these constraint > changes am going to do in a table which has 10 million records.... That's how I would do it, create the new constriaint, then drop the old one. I'n not aware of any syntax that would allow to rename a constraint. Cheers, tom