There are two transactions. One transaction I used
BEGIN RO for read-only transaction. While the other one I used
BEGIN to allow me adding a new column to my table called
dummy_table. This is what I've done :
However, after committing (even though I'm getting error transaction aborted), the column is successfully added.
For testing, I tried to
UPDATE one of the row instead, the tx2 able to
May I know what is the cause of the problem? Why is adding column causing the transaction to abort? What kind of improvement can I do?