NeonN
Neon6mo ago
3 replies
scattered-teal

Cannot use `pg_ivm` extension

I can install it ok using
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
ERROR:  schema "pg_ivm" does not exist
LINE 1: SELECT pg_ivm.create_immv('myview', 'SELECT * FROM Proto');


When I run SELECT table_name FROM information_schema.tables
I see a table names pg_ivm_immv

When 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?
Was this page helpful?