first of all, thanks for the great work. I used HeidiSQL with MySQL and MariaDB for over a decade. I had to switch to Postgres recently due to better support by my application framework. I am very happy to see, that the support in HeidiSQL for Postgres was getting better in the last releases.
I encountered some issues with a postgres export an reimport. I am not sure if this is the expected behaviour.
This is what I did: I exported a Postgress database to a sql file. First I selected INSERT IGNORE. The reimport to a new empty database did not start.
Then I selcected only INSERT. The import started but it had problems with the foreign key constraints of my database. My solution was to add the following line to beginning of the sql file: SET session_replication_role = replica; And at the end of the file back to: SET session_replication_role = origin
My question is: Should this be added on postgres export/import by default? maybe as a special option in the Options Dropdown?
Greetings from Braunschweig