sraoss / pg_ivm

IVM (Incremental View Maintenance) implementation as a PostgreSQL extension
Other
854 stars 24 forks source link

Simple update causes error with json fields #54

Closed nikophil closed 1 year ago

nikophil commented 1 year ago

Hello,

I'm trying to use this extension, and I'm facing a problem when trying to do a simple update on a table:

CREATE EXTENSION pg_ivm;
SELECT create_immv('my_awesome_view_program', 'SELECT * FROM program');
SELECT * from program where id = 1234; # displays some row
SELECT * from my_awesome_view_program where id = 1234; # displays the same row

UPDATE program SET title = 'foo' WHERE id = 1234; # Error: `[42883] ERROR: could not identify an equality operator for type json`

I used to have json fields, and tried to convert them into jsonb, but the error remains...

Thanks for your help!

bonus question: do you consider this extension safe and robust enough to be used in production? :innocent:

yugo-n commented 1 year ago

Currently, json type is not supported although it is not documented. I create a new issue for this; https://github.com/sraoss/pg_ivm/issues/61