Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Performance > rename constrai...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 2 Topic 4000 of 4156
Post > Topic >>

rename constraint

by sathiya.psql@[EMAIL PROTECTED] ("sathiya psql") Apr 17, 2008 at 05:33 PM

------=_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--
 




 2 Posts in Topic:
rename constraint
sathiya.psql@[EMAIL PROTE  2008-04-17 17:33:48 
Re: rename constraint
spreng@[EMAIL PROTECTED]   2008-04-17 14:14:38 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan13V112 Sun Jul 6 20:14:39 CDT 2008.