"pg_toast_2772_index" problem - Mailing list pgsql-jdbc

From Kathy Lo
Subject "pg_toast_2772_index" problem
Date
Msg-id c10e7feb0708192036p16f66d01qfa3ff85198b102bd@mail.gmail.com
Whole thread Raw
Responses Re: "pg_toast_2772_index" problem  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-jdbc
When I insert a record into a table using JDBC, I got the following exception:

org.postgresql.util.PSQLException: ERROR: index "pg_toast_27722_index"
is not a btree

I am using the following:

Fedora Core 4
Postgresql 8.0.3
Tomcat 5.5.17
JDBC postgresql-8.1.409.jdbc3.jar

The structure of the table is like the following:

one column = bigint, not null, foreign key
about 10 columns = varchar
about 10-15 columns = Text

When I insert a record without values in "Text" columns, OK!
When I insert a record containing values in almost all "Text" columns, FAILED!

--
Kathy Lo

pgsql-jdbc by date:

Previous
From: Oliver Jowett
Date:
Subject: Re: COPY FROM STDIN BINARY
Next
From: Tom Lane
Date:
Subject: Re: "pg_toast_2772_index" problem