sosedoff / pgweb

Cross-platform client for PostgreSQL databases
https://sosedoff.github.io/pgweb
MIT License
8.47k stars 716 forks source link

fix missing indexes by quoting schema/table name to ::regclass #711

Closed ashkulz closed 4 months ago

ashkulz commented 5 months ago

The same approach is used in pkg/statements/sql/table_schema.sql and a sample reproduction for the bug is:

CREATE SCHEMA test;
CREATE TABLE test.data (id INTEGER PRIMARY KEY, name TEXT);
CREATE UNIQUE INDEX "test.data_uniq" ON test.data (name);

Only the primary key is shown, and not the index created above.

sosedoff commented 4 months ago

Thanks for the bugfix!

ashkulz commented 4 months ago

Any ETA for a release? If there's none, I'd appreciate a response to this comment so I can work on it and have both included in the next release :slightly_smiling_face:

sosedoff commented 4 months ago

I dont have a particular schedule for releases, and usually try to get at least a few PRs (fixes/minor improvements) in before cutting a new version. Maybe a few weeks? maybe less