Skip to content

Add collection, too long text produces server error #174

@pyfection

Description

@pyfection

psycopg2.OperationalError: index row size 3712 exceeds maximum 2712 for index "collection_collection_title_text_type_id_a2f08220_uniq"
HINT: Values larger than 1/3 of a buffer page cannot be indexed.
Consider a function index of an MD5 hash of the value, or use full text indexing.

django.db.utils.OperationalError: index row size 3712 exceeds maximum 2712 for index "collection_collection_title_text_type_id_a2f08220_uniq"
HINT: Values larger than 1/3 of a buffer page cannot be indexed.
Consider a function index of an MD5 hash of the value, or use full text indexing.

This is an example text which is long enough to cause the error:

Uns óidn is de zaid zum ge bštimd
Via a bladl drógn fom vind
géd's zum uašprung zruk óis kind
Ven as bluad in deine ódan gfriad
Via dei heaz afhead zum šlógn
un du afi zu de engal fliagsd
Ná hób koa ángsd un lás di oafáh drógn
Vai es gibd vós náh dem lébm
du veasd šo ségn

Amói ségn ma uns vida
Amói šau i aa fo obm zua
Af meine óidn dóg leg i mi dánknd nida
un máh fia óle zaitn meine augn zua

Óis vós blaibd is de erinarung
un še lángsam vead da glár, das nix mea is via's vár
Ná soi de hofnung af a vidaséng
ma de gráfd in mein heaz šlóg legn, um vaida zum lébm

Amói ségn ma uns vida
Amói šau i aa fo obm zua
Af meine óidn dóg leg i mi dánknd nida
un máh fia óle zaitn meine aung zua

A liahd sui da laihdn bis in de evigkaid
Zua erinarung án de lébmszaid

Amói ségn ma uns vida
Amói šau i aa fo obm zua
Af meine óidn dóg leg i mi dánknd nida
un máh fia óle zaitn meine augn zua
Af meine óidn dóg leg i mi dánknd nida
un máh fia óle zaitn meine augn zua

Metadata

Metadata

Assignees

Labels

Projects

No projects

Relationships

None yet

Development

No branches or pull requests

Issue actions