Many RDBMSes use sequence caching to pre-generate sequence values in advance and store them in memory, allowing them to return new values quickly. If you are doing a lot of inserts that each call the sequence to get the next value, sequence caching is a good thing. Having to wait... [Read More]
NULL Means NULL
A Story of the Laziest User Recreation Script Ever
Encountering the NULL [Read More]
Altering Default Privileges For Fun and Profit
What NOT to expect when you're expecting.
One of the big changes I came upon as I transitioned from Oracle to PostgreSQL was how privileges are handled. In Oracle, an object’s schema also determines its owner, as the schema is generally that user’s objects. PostgreSQL disassociates schemas from users. Schemas do have owners, but a given user... [Read More]
USAGE Privilege Prevents Dropping Users
The Incident While cleaning up some obsolete user accounts, one of my DROP USER commands failed with: [Read More]
Moved to GitHub Pages
Yet Another Beautiful Jekyll Site!
If you’re reading this, then the migration has worked. My blog is now hosted via GitHub Pages. Many thanks to Kris Rice for his Blogger migration blog post and source code to get me set. [Read More]