if there is already a primary key, then I think the correct thing to do is to drop the first and add what you want. I have no experience doing this, but it seems logical.
ERXMigrationTable theTable = database.existingTableNamed(“yourTable”); theTable.dropPrimaryKey(columns); theTable.setPrimaryKey(columns); interesting that when I ask WOLips, it comes up with columns (plural). I assume you can add a multi column primary key. I have no idea where that would be useful. or this implications as a primary key does not want to be a class property. Ted On Oct 2, 2014, at 5:00 AM, Mark Wardle <[email protected]> wrote: > Dear all, > > I need to add a new primary key to a table that already contains data. > > Is it possible to use migrations to add this and have the column > auto-populated with a serial number? > > My other plan was to create an integer column and then, in code, iterate > through the objects manually setting the serial integer, and then later on > migrating that to a primary key. Would this then break primary key generation > for newly created objects? > > All advice appreciated! > > Many thanks, > > Mark > > > -- > Dr. Mark Wardle > Consultant Neurologist, University Hospital Wales, Cardiff, UK > Email: [email protected] or [email protected] Twitter: @mwardle > Telephone: 02920745274 (secretary) or facsimile: 02920744166 > > > > > > _______________________________________________ > Do not post admin requests to the list. They will be ignored. > Webobjects-dev mailing list ([email protected]) > Help/Unsubscribe/Update your Subscription: > https://lists.apple.com/mailman/options/webobjects-dev/tedpet5%40yahoo.com > > This email sent to [email protected]
_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
