I don't think TRUNCATE
's CASCADE
clause works (or if it does, it doesn't work like Postgres).
> CREATE TABLE reftbl (id INT PRIMARY KEY);
CREATE TABLE
> INSERT INTO reftbl VALUES (1);
INSERT 1
> CREATE TABLE fktbl (id INT REFERENCES reftbl, INDEX (id));
CREATE TABLE
> INSERT INTO fktbl VALUES (1);
INSERT 1
> TRUNCATE reftbl CASCADE;
pq: foreign key violation: non-empty columns [id] referenced in table "fktbl"