Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

[UI] Sort by

hakuno's profile image hakuno posted 6 years ago in Running SQL scripts Permalink

Hello again!

The problem: I can't sort by ID or anything on the data table.

The cause: I click over the column header and... the same return.

So I believe the app's query is incomplete:

SELECT * FROM "public"."ocorrencias" LIMIT 1000;

Thanks in advance,

Fedora 25 Workstation x64 w/ Wine; PostgreSQL 9.2.15; HeidiSQL 9.4.0.5137

denis's profile image denis posted 6 years ago Permalink

Sorting and filtering is totally broken. I reverted to previous version.

michail1982's profile image michail1982 posted 6 years ago Permalink

Same problem Windows10 Postgre 9.5.5 HeidiSQL 9.4.0.5137

michail1982's profile image michail1982 posted 6 years ago Permalink

started @ .r5136

hakuno's profile image hakuno posted 6 years ago Permalink

Plus, I don't even can see the "automatic columns listing" by typing the table name.

krisso's profile image krisso posted 6 years ago Permalink

Do we know when it will be fixed? There are much more broken things.

hakuno's profile image hakuno posted 6 years ago Permalink

Do we know when it will be fixed? There are much more broken things.

ASAP, surely.

But, if you can't await that, then you may downgrade. See denis' post.

Code modification/commit 3ffcafa from ansgarbecker, 6 years ago, revision 5138
Revert r5136, which removes support for single quotes in database names again, to fix a new bug when finding the right PG database name in a query like SET search_path TO E'information_schema', E'public'. See http://www.heidisql.com/forum.php?t=22799
ansgar's profile image ansgar posted 6 years ago Permalink

r5138 fixes that.

Never thought that r5136 would have caused this issue, but yes. That r5136 should have only added support for quotes in database names, as reported here. Then it broke that listing and sorting issue for PostgreSQL (not for MySQL and MSSQL!)

krisso's profile image krisso posted 6 years ago Permalink

Thanks, it works! (at least for Postgres).

r5138 fixes that.

Never thought that r5136 would have caused this issue, but yes. That r5136 should have only added support for quotes in database names, as reported here. Then it broke that listing and sorting issue for PostgreSQL (not for MySQL and MSSQL!)

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




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.