So the less obvious solution that works is to create a temporary
If the connection creating the table is long-lived, maybe make the table once and truncate instead.table. A little verbose, but I get to keep the types. `CREATE TEMPORARY TABLE _ ON COMMIT DROP AS SELECT OLD.*;` _ as a table name makes things a little easier to type. Rhys Peace & Love | Live Long & Prosper
