Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

hypopg_list_indexes() does not work normally #62

Closed
minhduchoang301 opened this issue Nov 24, 2021 · 2 comments
Closed

hypopg_list_indexes() does not work normally #62

minhduchoang301 opened this issue Nov 24, 2021 · 2 comments
Assignees
Labels

Comments

@minhduchoang301
Copy link

minhduchoang301 commented Nov 24, 2021

I follow the steps listed in the readme. Everything works fine, including other examples using hypopg's function with a command inside(). However, I have trouble with this command:

tpch=# SELECT * FROM hypopg_list_indexes();
ERROR: function hypopg_list_indexes() does not exist
LINE 1: SELECT * FROM hypopg_list_indexes();
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.

@minhduchoang301 minhduchoang301 changed the title hypopg function does not work normally hypopg_list_indexes() does not work normally Nov 24, 2021
@minhduchoang301
Copy link
Author

when I visualize which functions are installed, only these are:
Schema | Name | Owner | Access privileges | Language | Source code | Description
--------+----------------------+----------+-------------------+----------+----------------------+-------------
public | hypopg | postgres | | c | hypopg |
public | hypopg_create_index | postgres | | c | hypopg_create_index |
public | hypopg_drop_index | postgres | | c | hypopg_drop_index |
public | hypopg_get_indexdef | postgres | | c | hypopg_get_indexdef |
public | hypopg_relation_size | postgres | | c | hypopg_relation_size |
public | hypopg_reset | postgres | | c | hypopg_reset |
public | hypopg_reset_index | postgres | | c | hypopg_reset_index |
(7 rows)

@rjuju rjuju self-assigned this Nov 25, 2021
@rjuju rjuju added the bug label Nov 25, 2021
@rjuju
Copy link
Member

rjuju commented Nov 25, 2021

Hi,

Indeed a recent commit changed hypopg_list_indexes from a function to a view, so it's easier to use (mostly because you can rely on psql's autocompletion), and forgot to update the documentation.

Thanks for the report, this is now fixed: 6e2d7bf

@rjuju rjuju closed this as completed Nov 25, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

2 participants