Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Simple update causes error with json fields #54

Closed
nikophil opened this issue Feb 16, 2023 · 1 comment
Closed

Simple update causes error with json fields #54

nikophil opened this issue Feb 16, 2023 · 1 comment

Comments

@nikophil
Copy link

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? 😇

@nikophil nikophil changed the title Simple update causes Error Simple update causes error Feb 17, 2023
@nikophil nikophil changed the title Simple update causes error Simple update causes error with json fields Feb 17, 2023
@yugo-n
Copy link
Collaborator

yugo-n commented Jun 6, 2023

Currently, json type is not supported although it is not documented.
I create a new issue for this; #61

@yugo-n yugo-n closed this as completed Jun 6, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants