search

sraoss / pg_ivm

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

Install under Percona PostgreSQL 15.1 shows an error after execution #58

Closed GhaziTriki closed 1 year ago

GhaziTriki commented 1 year ago

Hello,

I installed the plugin under Percona PostgreSQL 15.1 and activated it. Then once I execute it I get the following error

SQL Error [42883]: ERROR: function create_immv(unknown, unknown) does not exist
  Hint: No function matches the given name and argument types. You might need to add explicit type casts.
  Position: 8
GhaziTriki commented 1 year ago

Installing the extension in the database makes it working. However when I try to update a tuple in the origin table I get this error SQL Error [42883]: ERROR: could not identify an equality operator for type xml

yugo-n commented 1 year ago

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