rhizome-ai commented on pull request #87: URL: https://github.com/apache/incubator-age/pull/87#issuecomment-877020432
> > "When an error occurred while a statement is executed (even though data retrieving), the session is blocked before rollback called." > > Is this the normal behavior of Psycopg? I am not sure I need to check, but if error occurs, rollback should occur and there shall not be any blocking. [https://www.psycopg.org/docs/usage.html#transactions-control](https://www.psycopg.org/docs/usage.html#transactions-control) The following database commands will be executed in the context of the same transaction – not only the commands issued by the first cursor, but the ones issued by all the cursors created by the same connection. Should any command fail, the transaction will be aborted and no further command will be executed until a call to the rollback() method. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
