In the process of working on a customer migration and came up with a neat query for finding tables that don’t have a primary key:

SELECT c.oid::REGCLASS::TEXT AS table
  FROM pg_class c
  JOIN pg_namespace n ON (n.oid = c.relnamespace)
  LEFT JOIN pg_constraint p ON (p.conrelid=c.oid AND p.contype = 'p')
 WHERE c.relkind IN ('p', 'r')
   AND n.nspname NOT IN ('pglogical', 'information_schema', 'bdr')
   AND n.nspname NOT LIKE 'pg\_%'
   AND p.conrelid IS NULL;

For anyone out there that is using pglogical, this is how you figure out if there are any tables that won’t work in the default replication set.

For some reason last night, I dreamed that I was going to give a speech some time later, and as part of it, I wanted to recite the opening of the Canterbury Tales. I believe my intent was to denote that the beauty of the prose can only be truly conveyed with proper pronunciation of the Middle English that has essentially been lost to time with the evolution of the language. And that we can progress with our lives and produce works just as aesthetic which will be similarly tied to our times and regions, but no less impactful.

So, it’s nice to know that Time Magazine has essentially admitted that the election was manipulated. At least they’re being honest about it now, though using Weasel Words to obfuscate a bit for plausible deniability.

Though I don’t quite know the exact day Luna was born, I know it was some time in late August of 1999. This means a cat I adopted shortly after I graduated from college is now 21 years old.

How often I think about all the things I want to do. The tasks I want to complete, one by one. The games I want to finish. The software I want to install on my web server and VM host. The Anime I want to catch up on. My Cayman, sitting neglected in the garage in need of having its bumper cover restored, among other bits and bobs.