Re: Changing Primary Index Question

Posted in 2003

ramesh.vasudevan@verizon.com — Wed, 3 Sep 2003 17:48:10 -0400 — source: Usenet: comp.databases.informix

All: Yes .. Primary key field doesn't allow NULL value. That is the major difference UNIQUE constraint and PRIMARY KEY constraint. btw - UNIQUE index is different from UNIQUE constraint. Thank You Ramesh Vasudevan "John Carlson" <john_carlson@whsm To: informix-list@iiug.org ithusa.com> cc: Sent by: Subject: Re: Changing Primary Index Question owner-informix-lis t@iiug.org 09/03/03 02:24 PM Please respond to "John Carlson" On Wed, 3 Sep 2003 10:12:18 -0500, "Bill Hamilton" <bham@finsco.com> wrote: > >GlacierYesterday I had to add a column to a table that had a 3-column >primary index >and this new column (a nullable column) had to become part of the primary >key. >The only way I could make it happen was to unload the table with null in >that spot, >drop the table, add the table, reload the table, add put back all other >contraints. > >Just for my future reference, is there an easier way (under IDS 7.31) ? > As far as I know, the definition of a PK doesn't allow a nullable column . . . . am I wrong? sending to informix-list