py-mysql2pgsql icon indicating copy to clipboard operation
py-mysql2pgsql copied to clipboard

Published 20 hours ago • verified publisher icon philipsoutham

Long index row problem.

Open kworr opened this issue 11 years ago • 1 comments

Recently seen this one:

psycopg2.OperationalError: index row size 3656 exceeds maximum 2712 for index "opins_text" 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.

Looks like not just any index that can be created in MySQL could be easily replicated to postgres. Any thoughts on this? I think about detecting such conditions, yelling loud and ignoring index creation.

kworr avatar Sep 03 '13 22:09 kworr

Also caught "psycopg2.OperationalError: index row requires 11296 bytes, maximum size is 8191" Didn't find any solution

sergey-zakharov avatar Jan 02 '15 14:01 sergey-zakharov