ERROR: transaction is read-only

Поиск
Список
Период
Сортировка
От Satish Burnwal (sburnwal)
Тема ERROR: transaction is read-only
Дата
Msg-id 3A8C969225424C4D8E6BEE65ED8552DA03832419@XMB-BGL-41C.cisco.com
обсуждение исходный текст
Ответы Re: ERROR: transaction is read-only
Список pgsql-jdbc
Hello all,
I am facing a serious issue in my app that uses jdbc and I am not
getting satisfactory answers from the posts either. I have set the conn
auto-commit to false but even after that I am getting the error : ERROR
: transaction is read-only - while executing a batch of 2 statements.

Statement1:
Smt.addBatch("DELETE from table1 where coln1 < 20");

Statement2:
Smt.addBatch("INSERT into table2 (SELECT coln1, coln2 from table3)");

Pls let me know how to resolve this.

Thanks in  advance,
-Satish

В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: [HACKERS] Fwd: Weird issues when reading UDT from stored function
Следующее
От: Maciek Sakrejda
Дата:
Сообщение: Re: ERROR: transaction is read-only