Indexing error

From: Johann Spies <jspies(at)sun(dot)ac(dot)za>
To: pgsql-admin(at)postgresql(dot)org
Subject: Indexing error
Date: 2010-10-05 07:34:56
Message-ID: 20101005073456.GA12185@sun.ac.za
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I have used EnterpriseDB's MigrationWizard to migrate a mysql database.
Everything went well except for:

Error Creating Index fltx_all: ERROR: index row size 2816 exceeds maximum 2712 for index "fltx_all"
Creating Index: fltx_adr
Error Creating Index fltx_adr: ERROR: index row size 2768 exceeds maximum 2712 for index "fltx_adr"
Creating Index: FK_authlink1

I have seen some old references and bug reports to this 2712 limit. Is
there a way to overcome it?

I am using 8.4.4 on Debian.

Regards
Johann
--
Johann Spies Telefoon: 021-808 4699
Databestuurder / Data manager

Sentrum vir Navorsing oor Evaluasie, Wetenskap en Tegnologie
Centre for Research on Evaluation, Science and Technology
Universiteit Stellenbosch.

"Therefore when thou doest thine alms, do not sound a
trumpet before thee, as the hypocrites do in the
synagogues and in the streets, that they may have
glory of men. Verily I say unto you, They have their
reward. But when thou doest alms, let not thy left
hand know what thy right hand doeth: That thine alms
may be in secret: and thy Father which seeth in secret
himself shall reward thee openly." Matthew 6:2-4

Browse pgsql-admin by date

  From Date Subject
Next Message Devrim GÜNDÜZ 2010-10-05 12:21:50 Re: [GENERAL] Data Not replicating
Previous Message Guillaume Lelarge 2010-10-05 06:39:23 Re: Validade dump file