Hi, problems with the length of text type : "Tuple is too big: size 9104, m=
ax=20
size 8128"


************************************************** *************************=
************************************************** *********

type Exception report

message

description The server encountered an internal error () that prevented it f=
rom=20
fulfilling this request.

exception

javax.servlet.ServletException: java.lang.Exception: java.sql.SQLException:=
=20
ERROR: Tuple is too big: size 9104, max size 8128

at=20
org.apache.struts.action.RequestProcessor.processE xception(RequestProcessor=
..java:545)
at=20
org.apache.struts.action.RequestProcessor.processA ctionPerform(RequestProce=
ssor.java:486)
at=20
org.apache.struts.action.RequestProcessor.process( RequestProcessor.java:274)
at=20
org.apache.struts.action.ActionServlet.process(Act ionServlet.java:1482)
at=20
org.apache.struts.action.ActionServlet.doGet(Actio nServlet.java:507)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:853)
at=20
org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(Applicatio=
nFilterChain.java:247)
at=20
org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterC=
hain.java:193)
at=20
org.apache.catalina.core.StandardWrapperValve.invo ke(StandardWrapperValve.j=
ava:256)
at=20
org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invo=
keNext(StandardPipeline.java:643)
at=20
org.apache.catalina.core.StandardPipeline.invoke(S tandardPipeline.java:480)
at=20
org.apache.catalina.core.ContainerBase.invoke(Cont ainerBase.java:995)
at=20
org.apache.catalina.core.StandardContextValve.invo ke(StandardContextValve.j=
ava:191)
at=20
org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invo=
keNext(StandardPipeline.java:643)
at=20
org.apache.catalina.core.StandardPipeline.invoke(S tandardPipeline.java:480)
at=20
org.apache.catalina.core.ContainerBase.invoke(Cont ainerBase.java:995)
at=20
org.apache.catalina.core.StandardContext.invoke(St andardContext.java:2416)
at=20
org.apache.catalina.core.StandardHostValve.invoke( StandardHostValve.java:18=
0)
at=20
org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invo=
keNext(StandardPipeline.java:643)
at=20
org.apache.catalina.valves.ErrorDispatcherValve.in voke(ErrorDispatcherValve=
..java:171)
at=20
org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invo=
keNext(StandardPi....



************************************************** *************************=
************************************************** *************************=
******************


...any idea and possible solutions ?? Thanks!=20



---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Noel Cornejo <ncornejo (AT) elsendero (DOT) es> writes:
Uh ... what Postgres version are you using? This sounds like you must
have a pre-7.1 server.

Update to something current (7.3.5 or 7.4.1 would be my recommendation).

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match