At FOSDEM someone asked how long 64 bit Transaction-IDs will last.
Imagine, you have a table and a colum is defined
NOT NULL. You (and I) expect, that
NULL arguments will not go into the table, but instead get rejected.
Letztens in einem IRC Channel:
Diese wannabe Datenbank macht immer alles anders:
Just stumbled about a curiosity: there are 82 functions in the current PostgreSQL part of PHP. Functions like pg_select(), which takes from you the burden of writing a
SELECT ... FROM tablename or pg_delete(), pg_insert() and pg_update() which all does, what do you expect:
UPDATE, and do the error checking. There are even 7 different functions for getting your results back into PHP.
But there is no function for starting, committing or rolling back a transaction. It seems, the message about the usefulness of transaction has yet not reached the PHP developers. Not that I’m surprised, the standard PHP/MySQL user seems to have no need for transactions …