From: Johann Spies <jspies@sun.ac.za>
To: pgsql-admin@postgresql.org
Subject: Indexing error
Date: Tue, 5 Oct 2010 09:34:56 +0200
Message-ID: <20101005073456.GA12185@sun.ac.za> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: jspies@sun.ac.za
Subject: Re: Indexing error
In-Reply-To: <20101005073456.GA12185@sun.ac.za>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox