SELECT * FROM pg_vector_index_stat does not work with partitions about pgvecto.rs HOT 4 CLOSED

It'll be fixed in next version and you could use

CREATE OR REPLACE VIEW pg_vector_index_stat AS
    SELECT
        C.oid AS tablerelid,
        I.oid AS indexrelid,
        C.relname AS tablename,
        I.relname AS indexname,
        (_vectors_index_stat(I.oid)).*
    FROM pg_class C JOIN
         pg_index X ON C.oid = X.indrelid JOIN
         pg_class I ON I.oid = X.indexrelid JOIN
         pg_am A ON A.oid = I.relam
    WHERE A.amname = 'vectors' AND C.relkind = 'r';

to fix the behavior in current version.

from pgvecto.rs.

Thanks for the quick reply @usamoi.
I tried your workaround but now I get a different error [XX000] ERROR: oid_ is null and even the query that previously did work now no longer works. Somehow I bricked it 😅 since even going back to the view without the AND C.relkind = 'r' fix is now broken. I guess I have to reinstall the extension, luckily it's just a test setup.

from pgvecto.rs.

Thanks for the quick reply @usamoi. I tried your workaround but now I get a different error [XX000] ERROR: oid_ is null and even the query that previously did work now no longer works. Somehow I bricked it 😅 since even going back to the view without the AND C.relkind = 'r' fix is now broken. I guess I have to reinstall the extension, luckily it's just a test setup.

Feel sorry for it. I forgot that the view is changed in development branch since v0.2.1.

If you are using v0.2.1,

CREATE OR REPLACE VIEW pg_vector_index_stat AS
    SELECT
        C.oid AS tablerelid,
        I.oid AS indexrelid,
        C.relname AS tablename,
        I.relname AS indexname,
        (_vectors_index_stat(I.relfilenode)).*
    FROM pg_class C JOIN
         pg_index X ON C.oid = X.indrelid JOIN
         pg_class I ON I.oid = X.indexrelid JOIN
         pg_am A ON A.oid = I.relam
    WHERE A.amname = 'vectors' AND C.relkind = 'r';

should work.

from pgvecto.rs.

It still produces the same error. But don't worry I will just reinstall the extension.

from pgvecto.rs.