Hacker News new | ask | show | jobs
by syslog 895 days ago
A decent database has transactions, so you can rollback your fat-fingered queries.
1 comments

Postgres and SQL Server have always had transactions; but unless you frame your DML in BEGIN TRANSACTION/[COMMIT|ROLLBACK], each statement is committed as executed.

If you broke in on Oracle, where you must explicitly commit statements (unless your client sets up auto-commit), this can take some getting used to.