matthijs·3 yıl önce·discussUsing `truncate` in combination with `cascade` is another that I found unexpected:"Automatically truncate all tables that have foreign-key references to any of the named tables, or to any tables added to the group due to CASCADE."So it will simply clear out other tables that reference table to truncate, even if you have `on delete set null` and the foreign key column is null.https://www.postgresql.org/docs/current/sql-truncate.html
matthijs·4 yıl önce·discussI was hoping for a more affordable 6K 32 (or 30) inch monitor but I'm afraid that won't happen anytime soon.
matthijs·16 yıl önce·discussHow do you store the words? In memory or do you use something like redis, mysql?
"Automatically truncate all tables that have foreign-key references to any of the named tables, or to any tables added to the group due to CASCADE."
So it will simply clear out other tables that reference table to truncate, even if you have `on delete set null` and the foreign key column is null.
https://www.postgresql.org/docs/current/sql-truncate.html