UNLOGGED table and ROLLBACK in PostgreSQL
From the documentation, my understanding is that when a ROLLBACK command is issued in a transaction, PostgreSQL typically employs the Write-Ahead Logging (WAL) mechanism to undo the changes made within that transaction. However, because changes made to UNLOGGED tables bypass the WAL, rolling back changes made to an unlogged table should theoretically have no effect. I attempted to replicate this scenario, yet I found that the changes were indeed rolled back.