lib/pgsync/task.rb in pgsync-0.6.2 vs lib/pgsync/task.rb in pgsync-0.6.3
- old
+ new
@@ -154,10 +154,10 @@
"UPDATE SET #{setter.join(", ")}"
end
destination.execute("INSERT INTO #{quoted_table} (SELECT * FROM #{quote_ident_full(temp_table)}) ON CONFLICT (#{on_conflict}) DO #{action}")
else
# use delete instead of truncate for foreign keys
- if opts[:defer_constraints]
+ if opts[:defer_constraints] || opts[:defer_constraints_v2]
destination.execute("DELETE FROM #{quoted_table}")
else
destination.truncate(table)
end
copy(copy_to_command, dest_table: table, dest_fields: fields)