Heidisql crashes when I am loading SQL script

Councelor's profile image Councelor posted 3 years ago in Import/Export Permalink

Hi! When I am loading the SQL script that creates the training database ("demo-small") from Postgres Pro website, the script freezes at query 131. So, the whole system freezes, then the screen fades off and a bit later my laptop reloads Windows. The database I am trying to load is not that big (99mb). I am using the latest build 11.0.0.5919 on Windows 10. Tried to run the same sql file using Heidi on more powerful PC - the result is still the same. When I am using psql command line, the database works just fine. Any clues why it's happening or how to fix it? Thank you.

BubikolRamios's profile image BubikolRamios posted 3 years ago Permalink

Try not to load, just run it. There is an option somewhere for that.

ansgar's profile image ansgar posted 3 years ago Permalink

There is also a new release, and already several new nightly builds. Please update and retry.

The "Run" option mentioned by BubikolRamios is in "File" > "Run SQL file".

Please login to leave a reply, or register at first.