Set case insensitive unique index with ERXMigrations
Set case insensitive unique index with ERXMigrations
- Subject: Set case insensitive unique index with ERXMigrations
- From: Jeff Schmitz <email@hidden>
- Date: Fri, 24 Mar 2017 12:46:10 -0500
Just a quick question on how to create a case insensitive unique index in an ERXMigration? e.g. I’d like to apply it to the below index.
ERXMigrationColumn[] entryColumns = { entryTable.existingColumnNamed("poolID"), entryTable.existingColumnNamed("c_name") }; entryTable.addUniqueIndex("poolUniqueEntry", entryColumns);
Also, how much is using a case insensitive unique index likely to affect performance on inserts?
Thanks! Jeff |
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden