[UI] Sort by

13 posts
[expired user #10326]'s profile image [expired user #10326] posted 8 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

7 posts
[expired user #9976]'s profile image [expired user #9976] posted 8 years ago Permalink

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

19 posts
[expired user #6771]'s profile image [expired user #6771] posted 8 years ago Permalink

Same problem Windows10 Postgre 9.5.5 HeidiSQL 9.4.0.5137

19 posts
[expired user #6771]'s profile image [expired user #6771] posted 8 years ago Permalink

started @ .r5136

13 posts
[expired user #10326]'s profile image [expired user #10326] posted 8 years ago Permalink

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

3 posts
[expired user #10333]'s profile image [expired user #10333] posted 8 years ago Permalink

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

13 posts
[expired user #10326]'s profile image [expired user #10326] posted 8 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, 8 years ago, revision 9.4.0.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
10362 posts
ansgar's profile image ansgar posted 8 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!)

3 posts
[expired user #10333]'s profile image [expired user #10333] posted 8 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.