New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

String is too long for tsvector (DataStore) #2837

Open
drnextgis opened this Issue Jan 16, 2016 · 1 comment

Comments

Projects
None yet
2 participants
@drnextgis

drnextgis commented Jan 16, 2016

Trying to add resource to DataStore but get an error:

sqlalchemy.exc.OperationalError: (OperationalError) string is too long for tsvector (3981192 bytes, max 1048575 bytes)
 'CREATE  INDEX "e8546e524414cd2dda84335b59aebc2cb83cebf2" ON "8bcedaa0-3630-4259-b94c-8bec3b82206a" USING gist(to_tsvector(\'english\', "GEOM"))' {}

Is there way to exclude some fields from tsvector column for preventing such error?

@wardi wardi self-assigned this Jan 19, 2016

@wardi

This comment has been minimized.

Contributor

wardi commented Jan 19, 2016

it looks like the decision about which fields are indexed is based only on the column type. You might need to change this part of the datastore code: https://github.com/ckan/ckan/blob/master/ckanext/datastore/db.py#L482

making the full-text indexing configurable would be great. Maybe something as simple as a configuration option with blacklisted column names (like "GEOM" in your case)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment