So now that I have the GMMK, I decided to see just how bad my old Logitech G710 keyboard was after five years of service. It… wasn’t pretty. Imagine five years of never once cleaning it in a four cat household, and never even doing the usual cotton swabs soaked in rubbing alcohol every few months. Well, imagine no further! Here it is with all of the key caps still installed:
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.