ERROR: current transaction is aborted, commands ignored until end of transaction block
来源:互联网 发布:ftp默认端口号 编辑:程序博客网 时间:2024/06/06 06:39
我们在PG数据库,关闭了事务的自动提交的情况下,会经常的遇到这样的问题
ERROR: current transaction is aborted, commands ignored until end of transaction block
为什么会造成了这样的问题,原因是
Postgres数据库中,同一事务中如果某次数据库操作中出错的话,那这个事务以后的数据库都会出错。
我们举个很简单的例子
test=# select * from test1;
ERROR: relation "test1" does not exist
LINE 1: select * from test1;
^
Time: 0.376 ms
这个时候,由于这不操作错误了,那么后面所有的这个会话中的操作都会报
ERROR: current transaction is aborted, commands ignored until end of transaction block
这个时候,我们要解决这个问题,只能够使用rollback,或者是commit去解决
这一点上面,PG做得不够人性化
ERROR: current transaction is aborted, commands ignored until end of transaction block
为什么会造成了这样的问题,原因是
Postgres数据库中,同一事务中如果某次数据库操作中出错的话,那这个事务以后的数据库都会出错。
我们举个很简单的例子
test=# select * from test1;
ERROR: relation "test1" does not exist
LINE 1: select * from test1;
^
Time: 0.376 ms
这个时候,由于这不操作错误了,那么后面所有的这个会话中的操作都会报
ERROR: current transaction is aborted, commands ignored until end of transaction block
这个时候,我们要解决这个问题,只能够使用rollback,或者是commit去解决
这一点上面,PG做得不够人性化
0 0
- postgresql ERROR: current transaction is aborted, commands ignored until end of transaction block
- ERROR: current transaction is aborted, commands ignored until end of transaction block
- ERROR: current transaction is aborted, commands ignored until end of transaction block
- 关于current transaction is aborted, commands ignored until end of transaction block与ON_ERROR_ROLLBACK
- 关于current transaction is aborted, commands ignored until end of transaction block与ON_ERROR_ROLLBACK
- PostgreSQL错误解决:ERROR: current transaction is aborted, commands ignored until end of transaction blockp
- PostgreSQL错误解决:ERROR: current transaction is aborted, commands ignored until end of transaction bloc
- GPDB current transaction is aborted
- postgresql错误解决 ERROR:current transaction is aborted
- Rails控制台出现current transaction is aborted错误的解决
- The transaction has aborted.
- The transaction has aborted.
- svn Transaction is out of date
- SQLite语法 END TRANSACTION
- block and transaction example
- 171.Which three statements/commands would cause a transaction to end? (Choose three.)
- Transaction
- Transaction
- [Getting and Cleaning data] Quiz 1
- 1.Activity的生命周期与启动模式
- 类似于spring+rmi,实现spring+thrift
- 数据库
- Postgresql 事务的提交与回滚
- ERROR: current transaction is aborted, commands ignored until end of transaction block
- Enumeration接口
- 进程间通信方式(全)
- Leetcode 87. Scramble String
- 发表在science 上的一种新的聚类算法
- java在线支付
- 安卓开发:提供ListView效率,实现双击回到顶部,删除子项
- Hello, Computer Graphics (MinGW)
- iOS开发之本地通知UILocalNotification