Open Cyborgscode opened 5 years ago
@Cyborgscode Hi, can you take a look at the latest version of Sequeler and let me know if the problem still persists?
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.
As a positive note: it feels way faster than Mysql Workbench 8
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'
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
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 <jbicha@ubuntu.com> Sun, 24 Oct 2021 08:31:47 -0400
sequeler (0.8.0-1) unstable; urgency=medium
* Initial release (Closes: #982497)
-- Yangfl <mmyangfl@gmail.com> 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:
i have indexes running on those tables.. no sign of them in the table structure display.