entity bean in postgreSQL

[eranhovav]

Hi

I'm working with a postgreSQL. I can establish a connection between the DB and the server (jboss). I can create tables in the DB by using a standalone java class. BUT when i'm trying to run an EJB client and create an entity bean i get this strange message:

11:44:30,244 ERROR [CabinEJB] Error checking if entity exists
java.sql.SQLException: ERROR: Index pk_cabinejb is not a btree

In the jboss log file was written:

2003-09-29 17:08:22,438 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.CabinEJB] Create: pk=1
2003-09-29 17:08:22,438 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.CabinEJB] Executing SQL: SELECT COUNT(*) FROM cabinejb WHERE id=?
2003-09-29 17:08:22,448 ERROR [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.CabinEJB] Error checking if entity exists
java.sql.SQLException: ERROR: Index pk_cabinejb is not a btree

What is the root of the problem? the postgreSQL driver or jboss driver? (Which one makes the query : SELECT COUNT(*) FROM cabinejb WHERE id=?)

I am a little confused, so I will happy for every help.

thank you.
eran.

[tsg26]

Hi,

to help you to debug the cause , why don't you run the postgresql under debug environment using the command postmaster -d 5 -D your datadir to locate the cause , it could be the corrupted primary key issue, just browse through the debug info provided my postmaster to confirm the fact.

Thanks