Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Tjw2p-0002NH-1q for pgsql-admin@arkaria.postgresql.org; Sat, 15 Dec 2012 18:01:03 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1Tjw2o-0001Of-4m for pgsql-admin@arkaria.postgresql.org; Sat, 15 Dec 2012 18:01:02 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Tjw2l-0001OX-W0 for pgsql-admin@postgresql.org; Sat, 15 Dec 2012 18:01:00 +0000 Received: from nm15.bullet.mail.bf1.yahoo.com ([98.139.212.174]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Tjw2i-00088K-VW for pgsql-admin@postgresql.org; Sat, 15 Dec 2012 18:00:58 +0000 Received: from [98.139.212.145] by nm15.bullet.mail.bf1.yahoo.com with NNFMP; 15 Dec 2012 18:00:54 -0000 Received: from [98.139.212.197] by tm2.bullet.mail.bf1.yahoo.com with NNFMP; 15 Dec 2012 18:00:54 -0000 Received: from [127.0.0.1] by omp1006.mail.bf1.yahoo.com with NNFMP; 15 Dec 2012 18:00:54 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 705780.32834.bm@omp1006.mail.bf1.yahoo.com Received: (qmail 20776 invoked by uid 60001); 15 Dec 2012 18:00:54 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1355594454; bh=sflbzqJKuXejtUWb4F096QqSrblJjrLAIoxSxv5WbsA=; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:Message-ID:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type; b=dCYAnsl5jTXM5hv6JNYw/jqhvCk43grcBFtUgYK9goWZ+DWfckoKF+1a+O3MybGWRFCtz4UDopH0TZSOaY3hFVIbqL2JoBZNRH8XzJNtjtBAZSTh4lzmQbVq4xi1avxTbxIllOMRaAR3RdAwndrqjua5oO4R/S1lhEcsxLDhhG8= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:Message-ID:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type; b=B86AnUTatQGbXXjcCYtiD0Fy4dQKSGLO8yjgrOUIA7xAVrrxzVXKZh/KlZgZ/+MVGD/qUbmkE/fPrHbvGI9nsRSUgE+FHaRQhT7kb2T7AuUjlveYBY1Lo0HH8Ak7RPpGmqPsDPPGKgLfedG68q2lydlsczfo/g1B7nfCyD4kbIU=; X-YMail-OSG: PXwzkMkVM1mcVvKLP6MvW5QwyheI4g3RVcU180yjpcLnT7J m4zqq9fFX9gIoSm_NaBqqRGdVCOx4xyglWiaE6BNbBPrX6lVuvTzpLe7zErs tkBEt29xnlV_yjWZUZgbbG5PcoEdoxGK..BiM.1w1nsGD3uRn8.IieiZ_HWx 37zxtzL4fOOAuYIqmraVZ1RT4oMGSRnOSDcQF5cGT7ZD5.m4G8Hxu64lWRim ueGTCaAbM.wfOFilw175jo0wI92nffmDwmloOdf3E6m0eyqgy_T7K4bwMMFL lTR74K9V13JXRyNP6pIOXtALNKZME7GgQYirptylHT8WlxzwAwN6_nyvfMgA kt6Tndycti7sb2xdY.QyYCsrwIP0N7SX16ZGJnVtXU7lvnU6ijzym5LFCsEL qDDWbLtnnKFtYDQuPfLGIObBUgN4dY9dts0DcsZdWmxbaggx_B0PtHUZMUtC 9Rbcf6D0hJehLaSNATDISorANZvMcef5nxQ5poMIGl9657aaD5i6.vM8- Received: from [39.47.255.28] by web160906.mail.bf1.yahoo.com via HTTP; Sat, 15 Dec 2012 10:00:54 PST X-Rocket-MIMEInfo: 001.001, RGVhciBBbGwsCgp3aGlsZSBpbnNlcnRpbmcgZGF0YSBpbiBkYXRhYmFzZShteSBvd24gY3JlYXRlZCBEQikgaSdtIGdldHRpbmcgdGhpcyBlcnJvcgoKCm9yZy5wb3N0Z3Jlc3FsLnV0aWwuUFNRTEV4Y2VwdGlvbjrCoEVSUk9SOiBpbmRleCByb3cgc2l6ZSAzMTc2IGV4Y2VlZHMgbWF4aW11bSAyNzEyIGZvciBpbmRleMKgImRlc2NyaXB0aW9uX2RlcGFydG1lbnRfb2ZfYWVyb25hdXRpY3NfYW5kX2FzdHJvbmF1dGljc181X3BrZXkiCmF0IG9yZy5wb3N0Z3Jlc3FsLmNvcmUudjMuUXVlcnlFeGVjdXRvckltcGwBMAEBAQE- X-Mailer: YahooMailWebService/0.8.128.478 Message-ID: <1355594454.19648.YahooMailNeo@web160906.mail.bf1.yahoo.com> Date: Sat, 15 Dec 2012 10:00:54 -0800 (PST) From: amjad usman Reply-To: amjad usman Subject: ERROR: index row size exceeds maximum 2712 for index To: "pgsql-admin@postgresql.org" MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="967773369-444865448-1355594454=:19648" X-Pg-Spam-Score: 1.4 (+) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org --967773369-444865448-1355594454=:19648 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Dear All,=0A=0Awhile inserting data in database(my own created DB) i'm gett= ing this error=0A=0A=0Aorg.postgresql.util.PSQLException:=A0ERROR: index ro= w size 3176 exceeds maximum 2712 for index=A0"description_department_of_aer= onautics_and_astronautics_5_pkey"=0Aat org.postgresql.core.v3.QueryExecutor= Impl.receiveErrorResponse(QueryExecutorImpl.java:1592)=0Aat org.postgresql.= core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327)=0Aat = org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192= )=0Aat org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Sta= tement.java:451)=0Aat org.postgresql.jdbc2.AbstractJdbc2Statement.executeWi= thFlags(AbstractJdbc2Statement.java:336)=0Aat org.postgresql.jdbc2.Abstract= Jdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:282)=0A=0Ai search= ed but could not understand how to resolve it.=0ADo you have any idea how c= an i get rid of this error?=0Aif postgres does not allow to increase index = row size then how DSpace is maintaining data in its db because it is saving= a lot of rows..???=0A=0AThanks for your time & consideration...=A0=0A=A0= =0ABest regards:=0AAmjad Usman=0A --967773369-444865448-1355594454=:19648 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable
Dear All,

while inserting data i= n database(my own created DB) i'm getting this error


org.postgresql.util.PSQLException: ERROR: index row size 3176 exceeds maximum 2712 f= or index "description_department_of_aeronautics_and_astronaut= ics_5_pkey"
=09at org.postgresql.core.v3.QueryExecuto= rImpl.receiveErrorResponse(QueryExecutorImpl.java:1592)
=09<= /span>at org.postgresql.core.v3.QueryExecutorImpl.processResults(= QueryExecutorImpl.java:1327)
= =09at org.postgresql.core.v3.= QueryExecutorImpl.execute(QueryExecutorImpl.java:192)
=09at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(Abstrac= tJdbc2Statement.java:451)
=09at org.postgresql.jdbc2.= AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.ja= va:336)
=09at org.postgresql.jdbc2.AbstractJdbc2State= ment.executeUpdate(AbstractJdbc2Statement.java:282)

i searched but could not understand how to resolve it.
Do you have any idea how can i get rid of this error?
if postgres does not allow to increase index row s= ize then how DSpace is maintaining data in its db because it is saving a lo= t of rows..???

Thanks for your time & consideration... 
=
 
Best regards:
Amjad Usman=
--967773369-444865448-1355594454=:19648--