Every once in awhile I’ll do some searching for things I posted online when I was younger. It’s fun to look back to my nascent technical days. I’ve never chronicled any of this but thought I would do just that, here on my blog.
I had a problem.
In a database system, a deadlock happens when two or more transactions wait for one another to release a lock. When this happens, the only course of action for the database engine is to kill one of the transaction to unblock the others.
A nice feature in PostgreSQL is that when you create a table, “a composite type is also automatically created, with the same name as the table, to represent the table’s row type” (quoted from the documentation). A composite type represents the structure of a row or record. This means you can work with a single record of a table much like an object in an OOP language.More Posts