length of insert stmt? - Mailing list pgsql-general

From chris markiewicz
Subject length of insert stmt?
Date
Msg-id 017301c0a7cb$6f0f7ea0$dbb846c6@cmarkiewicz
Whole thread Raw
In response to RE: FW: Optimisation of IN condition  ("Mayers, Philip J" <p.mayers@ic.ac.uk>)
Responses Re: length of insert stmt?  (Gavin Sherry <swm@linuxworld.com.au>)
List pgsql-general
hello

i received an error when someone ran an input stmt with a very long sting.
the field is of type 'text'.  The error (along with the statement) are shown
below.  what is the proper way do execute this insert?

The SQL Statement is too long - INSERT INTO accessor_group ( groupid,
groupname, grouptype, groupclassname, groupdescription, hidden ) VALUES (
22395, 'No TV and No Beer Make Homer Something SomethingNo TV and No Beer
Make Homer Something SomethingNo TV and No Beer Make Homer Something
SomethingNo TV and No Beer Make Homer Something SomethingNo TV and No Beer
Make Homer Something SomethingNo TV and No Beer Make Homer Something
SomethingNo TV and No Beer Make Homer Something SomethingNo TV and No Beer
Make Homer Something SomethingNo TV and No Beer Make Homer Something
SomethingNo TV and No Beer Make Homer Something SomethingNo TV and No Beer
Make Homer Something SomethingNo TV and No Beer Make Homer Something
SomethingNo TV and No Beer Make Homer Something SomethingNo TV and No Beer
Make Homer Something SomethingNo TV and No Beer Make Homer Something
SomethingNo TV and No Beer Make Homer Something SomethingNo TV and No Beer
Make Homer Something SomethingNo TV and No Beer Make Homer Something
SomethingNo TV and No Beer Make Homer Something SomethingNo TV and No Beer
Make Homer Something SomethingNo TV and No Beer Make Homer Something
SomethingNo TV and No Beer Make Homer Something SomethingNo TV and No Beer
Make Homer Something SomethingNo TV and No Beer Make Homer Something
SomethingNo TV and No Beer Make Homer Something SomethingNo TV and No Beer
Make Homer Something SomethingNo TV and No Beer Make Homer Something
SomethingNo TV and No Beer Make Homer Something SomethingNo TV and No Beer
Make Homer Something SomethingNo TV and No Beer Make Homer Something
SomethingNo TV and No Beer Make Homer Something SomethingNo TV and No Beer
Make Homer Something SomethingNo TV and No Beer Make Homer Something
SomethingNo TV and No Beer Make Homer Something SomethingNo TV and No Beer
Make Homer Something SomethingNo TV and No Beer Make Homer Something
SomethingNo TV and No Beer Make Homer Something SomethingNo TV and No Beer
Make Homer Something SomethingNo TV and No Beer Make Homer Something
SomethingNo TV and No Beer Make Homer Something SomethingNo TV and No Beer
Make Homer Something SomethingNo TV and No Beer Make Homer Something
SomethingNo TV and No Beer Make Homer Something SomethingNo TV and No Beer
Make Homer Something SomethingNo TV and No Beer Make Homer Something
SomethingNo TV and No Beer Make Homer Something SomethingNo TV and No Beer
Make Homer Something SomethingNo TV and No Beer Make Homer Something
SomethingNo TV and No Beer Make Homer Something SomethingNo TV and No Beer
Make Homer Something SomethingNo TV and No Beer Make Homer Something
SomethingNo TV and No Beer Make Homer Something SomethingNo TV and No Beer
Make Homer Something SomethingNo TV and No Beer Make Homer Something
SomethingNo TV and No Beer Make Homer Something SomethingNo TV and No Beer
Make Homer Something SomethingNo TV and No Beer Make Homer Something
SomethingNo TV and No Beer Make Homer Something SomethingNo TV and No Beer
Make Homer Something SomethingNo TV and No Beer Make Homer Something
SomethingNo TV and No Beer Make Homer Something SomethingNo TV and No Beer
Make Homer Something SomethingNo TV and No Beer Make Homer Something
SomethingNo TV and No Beer Make Homer Something SomethingNo TV and No Beer
Make Homer Something SomethingNo TV and No Beer Make Homer Something
SomethingNo TV and No Beer Make Homer Something SomethingNo TV and No Beer
Make Homer Something SomethingNo TV and No Beer Make Homer Something
SomethingNo TV and No Beer Make Homer Something SomethingNo TV and No Beer
Make Homer Something SomethingNo TV and No Beer Make Homer Something
SomethingNo TV and No Beer Make Homer Something SomethingNo TV and No Beer
Make Homer Something SomethingNo TV and No Beer Make Homer Something
SomethingNo TV and No Beer Make Homer Something SomethingNo TV and No Beer
Make Homer Something SomethingNo TV and No Beer Make Homer Something
SomethingNo TV and No Beer Make Homer Something SomethingNo TV and No Beer
Make Homer Something Something', 'community',
'com.commnav.sbh.objects.Group', 'No TV and No Beer Make Homer Something
SomethingNo TV and No Beer Make Homer Something SomethingNo TV and No Beer
Make Homer Something SomethingNo TV and No Beer Make Homer Something
SomethingNo TV and No Beer Make Homer Something SomethingNo TV and No Beer
Make Homer Something SomethingNo TV and No Beer Make Homer Something
SomethingNo TV and No Beer Make Homer Something SomethingNo TV and No Beer
Make Homer Something SomethingNo TV and No Beer Make Homer Something
SomethingNo TV and No Beer Make Homer Something SomethingNo TV and No Beer
Make Homer Something SomethingNo TV and No Beer Make Homer Something
SomethingNo TV and No Beer Make Homer Something SomethingNo TV and No Beer
Make Homer Something SomethingNo TV and No Beer Make Homer Something
SomethingNo TV and No Beer Make Homer Something SomethingNo TV and No Beer
Make Homer Something SomethingNo TV and No Beer Make Homer Something
SomethingNo TV and No Beer Make Homer Something SomethingNo TV and No Beer
Make Homer Something SomethingNo TV and No Beer Make Homer Something
SomethingNo TV and No Beer Make Homer Something SomethingNo TV and No Beer
Make Homer Something SomethingNo TV and No Beer Make Homer Something
SomethingNo TV and No Beer Make Homer Something SomethingNo TV and No Beer
Make Homer Something SomethingNo TV and No Beer Make Homer Something
SomethingNo TV and No Beer Make Homer Something SomethingNo TV and No Beer
Make Homer Something SomethingNo TV and No Beer Make Homer Something
SomethingNo TV and No Beer Make Homer Something SomethingNo TV and No Beer
Make Homer Something SomethingNo TV and No Beer Make Homer Something
SomethingNo TV and No Beer Make Homer Something SomethingNo TV and No Beer
Make Homer Something SomethingNo TV and No Beer Make Homer Something
SomethingNo TV and No Beer Make Homer Something SomethingNo TV and No Beer
Make Homer Something SomethingNo TV and No Beer Make Homer Something
SomethingNo TV and No Beer Make Homer Something SomethingNo TV and No Beer
Make Homer Something SomethingNo TV and No Beer Make Homer Something
SomethingNo TV and No Beer Make Homer Something SomethingNo TV and No Beer
Make Homer Something SomethingNo TV and No Beer Make Homer Something
SomethingNo TV and No Beer Make Homer Something SomethingNo TV and No Beer
Make Homer Something SomethingNo TV and No Beer Make Homer Something
SomethingNo TV and No Beer Make Homer Something SomethingNo TV and No Beer
Make Homer Something SomethingNo TV and No Beer Make Homer Something
SomethingNo TV and No Beer Make Homer Something SomethingNo TV and No Beer
Make Homer Something SomethingNo TV and No Beer Make Homer Something
SomethingNo TV and No Beer Make Homer Something SomethingNo TV and No Beer
Make Homer Something SomethingNo TV and No Beer Make Homer Something
SomethingNo TV and No Beer Make Homer Something SomethingNo TV and No Beer
Make Homer Something SomethingNo TV and No Beer Make Homer Something
SomethingNo TV and No Beer Make Homer Something SomethingNo TV and No Beer
Make Homer Something SomethingNo TV and No Beer Make Homer Something
SomethingNo TV and No Beer Make Homer Something SomethingNo TV and No Beer
Make Homer Something SomethingNo TV and No Beer Make Homer Something
SomethingNo TV and No Beer Make Homer Something SomethingNo TV and No Beer
Make Homer Something SomethingNo TV and No Beer Make Homer Something
SomethingNo TV and No Beer Make Homer Something SomethingNo TV and No Beer
Make Homer Something SomethingNo TV and No Beer Make Homer Something
SomethingNo TV and No Beer Make Homer Something SomethingNo TV and No Beer
Make Homer Something SomethingNo TV and No Beer Make Homer Something
SomethingNo TV and No Beer Make Homer Something SomethingNo TV and No Beer
Make Homer Something SomethingNo TV and No Beer Make Homer Something
SomethingNo TV and No Beer Make Homer Something SomethingNo TV and No Beer
Make Homer Something SomethingNo TV and No Beer Make Homer Something
SomethingNo TV and No Beer Make Homer Something SomethingNo TV and No Beer
Make Homer Something SomethingNo TV and No Beer Make Homer Something
SomethingNo TV and No Beer Make Homer Something SomethingNo TV and No Beer
Make Homer Something SomethingNo TV and No Beer Make Homer Something
SomethingNo TV and No Beer Make Homer Something Somethingv', 'false' )
    at org.postgresql.Connection.ExecSQL(Connection.java:324)
    at org.postgresql.jdbc2.Statement.execute(Statement.java:273)
    at com.commnav.sbh.framework.persist.JDBCEngine.create(JDBCEngine.java:44)
    at
com.commnav.sbh.framework.persist.PersistenceObject.create(PersistenceObject
.java:387)
    at
com.commnav.sbh.applications.group.GroupAddStrategy.process(GroupAddStrategy
.java:87)
    at.................... etc, etc.

Any information/comments would be appreciated.

thanks
chris


pgsql-general by date:

Previous
From: "Mayers, Philip J"
Date:
Subject: RE: FW: Optimisation of IN condition
Next
From: Alfred Perlstein
Date:
Subject: Re: unbalanced indexes -> fixed via dump/restore?