Problemas al trabajar con secuencias utilizando PostgreSQL >=9.x

What steps will reproduce the problem?
1. Iniciar el desarrollo de un plugin
2. Modificar el campo de alguna tabla
3. Ver el registro de errores

What is the expected output? 
El registro de errores debería estar vacío y deberían ingresarse entradas en 
la tabla ad_changelog.

What do you see instead?
No se generar entradas en ad_changelog. 

Stack trace

===========> DB.getSQLValue: SELECT nextval('seq_ad_changelog') [12]
org.postgresql.util.PSQLException: ERROR: cannot execute nextval() in a 
read-only transaction; State=25006; ErrorCode=0
    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273)
    at org.openXpertya.util.CPreparedStatement.executeQuery(CPreparedStatement.java:205)
    at org.openXpertya.util.DB.getSQLValue(DB.java:1179)
    at org.openXpertya.util.DB.getSQLValue(DB.java:1168)
    at org.openXpertya.model.MChangeLog.insertDirect(MChangeLog.java:303)
    at org.openXpertya.model.MSession.changeLog(MSession.java:177)
    at org.openXpertya.model.PO.logging(PO.java:4132)
    at org.openXpertya.model.PO.saveUpdate(PO.java:2187)
    at org.openXpertya.model.PO.save(PO.java:1850)
    at org.openXpertya.model.MTable.dataSavePO(MTable.java:2405)
    at org.openXpertya.model.MTable.dataSave(MTable.java:1645)
    at org.openXpertya.model.MTab.dataSave(MTab.java:1116)
    at org.openXpertya.apps.APanel.cmd_save(APanel.java:1701)
    at org.openXpertya.apps.APanel.actionPerformed(APanel.java:1529)
    at org.openXpertya.apps.AppsAction.actionPerformed(AppsAction.java:292)

Original issue reported on code.google.com by saulo....@orbital.com.ar on 10 Nov 2014 at 7:47

maximilianocorrea / libertya

Problemas al trabajar con secuencias utilizando PostgreSQL >=9.x #40