Allowing PostgreSQL to use an index when the query uses the LIKE-operator

Posted by Eric Bartels

When enabling search in database its very important to have the appropriate indexes defined to make the queries as fast as possible. If your query looks like this (and the appropriate index is defined) the index can be used by the database (the query planner) even with the LIKE-operator. So fast wildcard-searches are possible … [...]

Cannot complete this action – error when adding a ContentType to a list

Posted by Eric Bartels

Today I got a nice error from my SharePoint development box after I tried to add a certain Content Type to a list. Cannot complete this action. Please try again. at Microsoft.SharePoint.Library.SPRequestInternalClass.AddField(String bstrUrl, String bstrListName, String bstrSchemaXml, Int32 grfAdd) at Microsoft.SharePoint.Library.SPRequest.AddField(String bstrUrl, String bstrListName, String bstrSchemaXml, Int32 grfAdd) Tell me This is an error message [...]