0

I have run below statement without begin then, show a warning message (WARNING: there is no transaction in progress) like below image. But actually that table was deleted. Why it is not roll backed? Is there any effect in future transaction on that table?

rollback without begin

1 Answer 1

3

Autocommit is on by default in psql, so every statement is implicitly committed. In other words, after delete a commit was issued by the driver, which closed the active transaction, then obviously rollback didn't do anything and resulted in the warning you saw.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.