-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 10/11/06 19:15, Richard Broersma Jr wrote: >>>> I doesn't appear that ALTER TABLE can change constraint >>>> characteristics. You'd have to drop/recreate, no? >>> Now that you mention it, I've never tried it or seen it done. >>> Here I what I came up with: >>> >> [snip] >>> >>> It is nice to see things work so well. :-) >> It would be interesting to see how well it works on a 50M row >> table. > > Good point, but hopefully only small fraction of the 50 M rows > would be affected and hopefully updating primary keys isn't a > common occurrence. I was thinking of the ALTER TABLE ... ADD CONSTRAINT column. - -- Ron Johnson, Jr. Jefferson LA USA Is "common sense" really valid? For example, it is "common sense" to white-power racists that whites are superior to blacks, and that those with brown skins are mud people. However, that "common sense" is obviously wrong. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.5 (GNU/Linux) iD8DBQFFLY2nS9HxQb37XmcRAjYNAKDibxx/tTAXZxg8uCp3jJfaTGeb/ACgqQdT yCvtOQMz0vGak51Gg1sC/OE= =Q+Fz -----END PGP SIGNATURE-----
