[GENERAL] jdbc: ERROR transaction is read-only

I am using the postgresql-8.2.506.jdbc4.jar file My jdbc connections are setReadOnly(false) When attempting an insert I get org.postgresql.util.PSQLException: ERROR: transaction is read-only ideas? ---(end of broadcast)--- TIP 3: Have you che

[GENERAL] newbie: update timestamp trigger?

Whenever a row is updated in a table with a timestamp column. How do I write a trigger to set that timestamp column to now() or the current timestamp? thanks ---(end of broadcast)--- TIP 6: explain analyze is your friend