Neon•8mo ago•

3 replies

scattered-teal

Cannot use `pg_ivm` extension

I can install it ok using

CREATE EXTENSION pg_ivm;

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');

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');

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

SELECT table_name FROM information_schema.tables

I see a table names

pg_ivm_immv

pg_ivm_immv

When i run

SELECT * FROM pg_extension;

SELECT * FROM pg_extension;

I get a row containing

pg_ivm

pg_ivm


73728    pg_ivm    16387    11    FALSE    1.9    {73730}    {""}


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?