org.postgresql.util.PSQLException

tip

Try downgrading PostgresSQL server to 9.5 or update your PostgresSQL driver to 9.4-1211 with the following command: 9.4.1211

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

  • 1.2RC1 is available for testing
    via by Guillaume Bort,
  • Ebean.saveManyToManyAssociations
    via by Unknown author,
    • org.postgresql.util.PSQLException: ERROR: update or delete on table "c\_bankaccount" violates foreign key constraint "cbankaccount\_cbankacctacct" on table "c\_bankaccount\_acct" Detail: Key (c\_bankaccount\_id)=(1000001) is still referenced from table "c\_bankaccount\_acct".; State=23503; ErrorCode=0 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1316) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191) at org.postgresql.jdbc2.AbstractJdbc2Connection.executeTransactionCommand(AbstractJdbc2Connection.java:653) at org.postgresql.jdbc2.AbstractJdbc2Connection.commit(AbstractJdbc2Connection.java:673) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.postgresql.ds.jdbc23.AbstractJdbc23PooledConnection$ConnectionHandler.invoke(AbstractJdbc23PooledConnection.java:357) at $Proxy2.commit(Unknown Source) at org.compiere.util.Trx.commit(Trx.java:380) at org.compiere.util.Trx.commit(Trx.java:453) at org.compiere.model.PO.delete(PO.java:2486) at org.compiere.model.GridTable.dataDelete(GridTable.java:2248) at org.compiere.model.GridTab.dataDelete(GridTab.java:920)

    Users with the same issue

    guizmaii
    26 times, last one,
    derprogger
    1 times, last one,
    Unknown User
    7 times, last one,
    jokester
    2 times, last one,
    Unknown visitor2 times, last one,
    89 more bugmates