Skip to content

Instantly share code, notes, and snippets.

View dfcarpenter's full-sized avatar

Daniel Carpenter dfcarpenter

View GitHub Profile
@dfcarpenter
dfcarpenter / dependent_objects.sql
Created July 10, 2019 18:13
Find objects that depend on a specific column
SELECT
d.objid::regclass AS owning_object,
d.refobjid::regclass AS dependent_object,
a.attname AS dependent_column,
d.deptype -- The meaning of this type is documented at https://www.postgresql.org/docs/current/catalog-pg-depend.html
FROM pg_catalog.pg_depend d
LEFT JOIN pg_catalog.pg_attribute a ON d.refobjid = a.attrelid
AND d.refobjsubid = a.attnum
WHERE refobjid = '<table>'::regclass
AND a.attname = '<column>';
@dfcarpenter
dfcarpenter / machine.js
Last active November 26, 2019 00:50
Generated by XState Viz: https://xstate.js.org/viz
// Available variables:
// - Machine
// - interpret
// - assign
// - send
// - sendParent
// - spawn
// - raise
// - actions