pyfection / servare

The Django code for the website
http://www.servare.org
5 stars 2 forks source link

Add collection, too long text produces server error #174

Open pyfection opened 5 years ago

pyfection commented 5 years ago

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