Description

When using "Export database as SQL" on tables that have a large number of rows the output contains duplicates of the same row. The larger the amount of data the more duplicates. The duplication is also not consistent as some rows are not duplicated, some are duplicated 3 times or 2 times.

This behavior occurs both when trying to export to a sql file and also when exporting directly to another database where at around 50,000 rows it displays an error message duplicate key value violates unique constraint.

HeidiSQL version

12.10.0.7042

Database server version

Postgresql 17

Reproduction recipe

Export a table with over 100k rows that has a primary key to a sql rile. Attempt to run the file which contains the sql inserts into the same table in another database

Error/Backtrace