Chattopadhyay asked: > My application based on Java servlets was running fine with > version PostgreSQL 7.x, but started giving error: > "transaction is read-only", in version 8.0 and 8.1. I am > using Suse Linux 9.3/PostgreSQL 8.0 or Suse Linux > 10.1/PostgreSQL 8.1. I am using JDBC 3 drivers and all > connections are in auto-commit mode. Could you please tell me > what's going wrong. [...] > I'd really appreciate if anyone could suggest a pointer for > further investigation, if not an outright solution.
Via JDBC, ask the database to SHOW default_transaction_read_only and look at the output. If that is 'true', look at SELECT source FROM pg_settings WHERE name='default_transaction_read_only' If it is false, check java.sql.Connection.isReadOnly(). It is 'false' by default, but maybe is changed somewhere in your code. Yours, Laurenz Albe ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster