TRUNCATE TABLE YYYYY RESTART IDENTITY
I am seeing this error message:
ERROR: cannot truncate a table referenced in a foreign key constraint DETAIL: Table "XXXXX" references "YYYYY". HINT: Truncate table "XXXXX" at the same time, or use TRUNCATE ... CASCADE.
Of the two suggestions in
TRUNCATE ... CASCADEmakes sense, and works, but is less explicit because one must inspect
YYYYYto see where the cascade goes. That makes me want to try the other option:
Truncate table "XXXXX" at the same time, but my question:
What does it mean to truncate a table
at the same time?
I tried adding a
TRUNCATE XXXXX... (and wrapping them both in a
COMMIT), but that yields the same error.