database_cleaner
database_cleaner copied to clipboard
Cannot truncate a table referenced in a foreign key constraint (ActiveRecord::StatementInvalid)
trafficstars
> DatabaseCleaner.clean_with(:truncation, pre_count: true)
(reverb):1:in `<main>': PG::FeatureNotSupported: ERROR: cannot truncate a table referenced in a foreign key constraint (ActiveRecord::StatementInvalid)
DETAIL: Table "table1" references "table2".
HINT: Truncate table "table1" at the same time, or use TRUNCATE ... CASCADE.
/root/project/vendor/bundle/ruby/3.1.0/gems/activerecord-7.2.1/lib/active_record/connection_adapters/postgresql/database_statements.rb:56:in `exec': ERROR: cannot truncate a table referenced in a foreign key constraint (PG::FeatureNotSupported)
DETAIL: Table "table1" references "table2".
HINT: Truncate table "table1" at the same time, or use TRUNCATE ... CASCADE.
Rails 7.2.1 ActiveRecord 7.2.1 DatabaseCleaner 2.0.2 DatabaseCleaner-ActiveRecord 2.2.0