Received: from localhost (unknown [200.46.204.183])
	by developer.postgresql.org (Postfix) with ESMTP id 84B6B2E004A
	for <pgsql-performance-postgresql.org@developer.postgresql.org>;
	Thu, 17 Apr 2008 09:03:59 -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 97110-09
	for <pgsql-performance-postgresql.org@developer.postgresql.org>;
	Thu, 17 Apr 2008 09:03:49 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5
Received: from an-out-0708.google.com (an-out-0708.google.com
 [209.85.132.244])
	by developer.postgresql.org (Postfix) with ESMTP id CD0482E0044
	for <pgsql-performance@postgresql.org>;
	Thu, 17 Apr 2008 09:03:49 -0300 (ADT)
Received: by an-out-0708.google.com with SMTP id c36so9275ana.33
	for <pgsql-performance@postgresql.org>;
	Thu, 17 Apr 2008 05:03:48 -0700 (PDT)
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:mime-version:content-type;
	bh=/+VP93KaCRWHj8sMDGK8xScBjGcvlKPApt3HTyZX9pA=;
	b=lO31c/9/Ohe+pJBWzPOuHBYgMEpq4sFs2nMXvONLJxrDVRUW2MN8raj2lYDnTu8/WTLeADbFmOGHmamkuyZiqnE5XnVmwtnT+IRU5phbW3aofMwKuzmnlpMFIsEFwivHhJgTAXNxqKJNM8mR7U/1d9t3ush5FN6cfvH8OIn0lJk=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:to:subject:mime-version:content-type;
	b=ru6MiwALQRThlnllGhJ+hPPxFNGktsEQzezquWYb/YUnwhhZWdIYikAOpKKiQdpNkrW/+X5ZMz9uy/+wIRf64sEbBIOlY+3nc2w52K1Cdxh4lq2kbcG8ez3TtiDNt+yVl9w1nH/ucgZO6TLo0CzZAxuYOOg+7QjtCRBNZmpKax4=
Received: by 10.100.252.17 with SMTP id z17mr2473974anh.6.1208433828628;
	Thu, 17 Apr 2008 05:03:48 -0700 (PDT)
Received: by 10.100.105.20 with HTTP; Thu, 17 Apr 2008 05:03:48 -0700 (PDT)
Message-ID: <f966c2ee0804170503q7686d4mad785d11fa3753e5@mail.gmail.com>
Date: Thu, 17 Apr 2008 17:33:48 +0530
From: "sathiya psql" <sathiya.psql@gmail.com>
To: "pgsql-performance@postgresql.org" <pgsql-performance@postgresql.org>
Subject: rename constraint
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_22861_30724944.1208433828621"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200804/234
X-Sequence-Number: 29727

------=_Part_22861_30724944.1208433828621
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi,

I need to change the name of the constraint.,

What will be the best way to do this.

Am using postgres 8.1.

Is it possible to do the rename constraint( like renaming a column), i don't
know how to do this ?

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....

------=_Part_22861_30724944.1208433828621
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi,<br><br>I need to change the name of the constraint.,<br><br>What will be the best way to do this.<br><br>Am using postgres 8.1.<br><br>Is it possible to do the rename constraint( like renaming a column), i don&#39;t know how to do this ?<br>
<br>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....<br>

------=_Part_22861_30724944.1208433828621--