pg_ivm on Postgres 18 not working
🪲Bug
pg_ivm was working great on Postgres 17 with Neon (ran migrations using create_immv with no issue), but I ran into a bug that was fixed in pg_ivm 1.10. I had to migrate to Postgres 18 because of it, and the bug that I was seeing went away. However, now the same migrations with create_immv are failing. Has Neon not set up pg_ivm fully on Postgres 18 yet?
I'm just running:
SELECT create_immv('...', '...')
in the Neon console and I'm getting:
ERROR: function create_immv(unknown, unknown) does not exist (SQLSTATE 42883)
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
pg_ivm definitely exists - if I run CREATE EXTENSION pg_ivm, it says that the extension already exists.
I'm just running:
SELECT create_immv('...', '...')
in the Neon console and I'm getting:
ERROR: function create_immv(unknown, unknown) does not exist (SQLSTATE 42883)
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
pg_ivm definitely exists - if I run CREATE EXTENSION pg_ivm, it says that the extension already exists.
