kayesh

Importing/Indexing database (MySQL or SQL Server) in Solr using Data Import Handler

download and install Solr from http://lucene.apache.org/solr/.

you can access Solr admin from your browser: http://localhost:8983/solr/

use the port number used in installation.

	SELECT conname
	FROM pg_constraint
	WHERE conrelid = 'account_emailaddress'::regclass
	AND contype = 'u';


	ALTER TABLE account_emailaddress DROP CONSTRAINT account_emailaddress_email_key;