Cannot use `pg_ivm` extension
I can install it ok using
But when I try to use the extension .
eg
I get an error
When I run
I see a table names
When i run
I get a row containing
I have also tried restarting the compute endpoint. - It did not help.
Am I just using it wrong, or is it not setup or installed correctly?
CREATE EXTENSION pg_ivm; and that succeeds.But when I try to use the extension .
eg
SELECT pg_ivm.create_immv('myview', 'SELECT * FROM Proto');I get an error
When I run
SELECT table_name FROM information_schema.tablesI see a table names
pg_ivm_immvWhen i run
SELECT * FROM pg_extension;I get a row containing
pg_ivm
73728 pg_ivm 16387 11 FALSE 1.9 {73730} {""}
I have also tried restarting the compute endpoint. - It did not help.
Am I just using it wrong, or is it not setup or installed correctly?
