indices are not shown in the table structure

[Cyborgscode]

i have indexes running on those tables.. no sign of them in the table structure display.

[Alecaddd]

@Cyborgscode Hi, can you take a look at the latest version of Sequeler and let me know if the problem still persists?

[Cyborgscode]

Info: Version 7.4.1 Binary: FC30 /usr/bin/com.github.alecaddd.sequeler <-- not really a good name for a file.

** Not fixed **

Tab "Relations" shows only 1 of 4 indices, the primary one.

[Cyborgscode]

As a positive note: it feels way faster than Mysql Workbench 8

[Alecaddd]

All right, I'm digging deeper into this issue. Can you run this query inside the query tab and tell me if the INDEXES are shown? Also, a screenshot or the list of column names would be super helpful, thanks.

SELECT * FROM information_schema.COLUMNS WHERE table_name = 'your_table_name'

[Cyborgscode]

[Alecaddd]

And what if you run SHOW INDEX FROM <your_table>? Do you get a different list from what's shown in the Relationship table?

For me all the indexes and foreign keys are properly listed

[hdijkema]

I've got the same issue with sequeler on ubuntu 22.04. Regrettebly there's no version information to be found. Also the executable is difficult to find. I found it with find -type f /usr | grep -i sequeler, and that results in /usr/bin/com.github.alecaddd.sequeler. There's no way to start the application with e.g. --version.

So this is the version information I've got for Ubuntu 22.04:

sequeler (0.8.0-1build1) jammy; urgency=medium
  * No-change rebuild against latest granite
 -- Jeremy Bicha <[email protected]>  Sun, 24 Oct 2021 08:31:47 -0400

sequeler (0.8.0-1) unstable; urgency=medium
  * Initial release (Closes: #982497)
 -- Yangfl <[email protected]>  Mon, 15 Feb 2021 20:27:08 +0800

I also do not get index information in the relations tab, while there are indices defined.

Structure:

Relations:

Indices queried from postgresql:

Also, 'views' are not shown. But when I query them from postgresql, I get: