Carla,

You cannot create a primary index with a FOR clause programmitically. The solution is to change the index to candidate and add a surrogate primary key whose vlaue is never duplicated ever. Then you don't need the for clause anymore.