org.postgresql.util.PSQLException: ERROR: OLD used in query that is not in a rule; State=42601; ErrorCode=0

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Samebug tips

,
Expert tip

Try downgrading PostgresSQL server to 9.5 or update your PostgresSQL driver to 9.4-1211 with the following command: <postgresql.version>9.4.1211</postgresql.version>

Solutions on the web

via adempiere by vpj-cd
, 1 year ago
ERROR: OLD used in query that is not in a rule; State=42601; ErrorCode=0
via adempiere by gohyc
, 1 year ago
ERROR: null value in column "pricelastpo" violates not-null constraint; State=23502; ErrorCode=0
via adempiere by gunda
, 1 year ago
ERROR: current transaction is aborted, commands ignored until end of transaction block; State=25P02; ErrorCode=0
via adempiere by poporopo
, 1 year ago
ERROR: current transaction is aborted, commands ignored until end of transaction block; State=25P02; ErrorCode=0
via adempiere by mjudd
, 1 year ago
ERROR: current transaction is aborted, commands ignored until end of transaction block; State=25P02; ErrorCode=0
via adempiere by vpj-cd
, 1 year ago
ERROR: column "entitytype" cannot be cast to type "pg\_catalog.numeric"; State=42804; ErrorCode=0
org.postgresql.util.PSQLException: ERROR: OLD used in query that is not in a rule; State=42601; 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.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:337)
at sun.reflect.GeneratedMethodAccessor84.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 2 years ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Once, 3 months ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
102 more bugmates

Know the solutions? Share your knowledge to help other developers to debug faster.