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
ACLs FTW
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]
Beware (Sort-Of) Ambiguous Column Names In Sub-Selects
This morning I received an UPDATE statement from a developer that I was testing. It ran without errors but then I saw that it updated 5 rows when it should have only updated 3. The reason gave me a little shock so I whipped up a simple test-case to reproduce...
[Read More]