Materialized views and check constraints

Started by Nonamealmost 2 years ago1 messages
Jump to latest
#1Noname
ZeroImpl@gmail.com

Hi,

Is there any way to add check constraints to a materialized view, or plans
to add this feature in the future?

Attempting to use "ALTER TABLE tablename ADD CHECK(...)" or "ALTER
MATERIALIZED VIEW" result in error:

ERROR: "tablename" is not a table or foreign table

Check constraints are used by the optimizer, eg for partition removal, so
this would be a useful feature to me.

--
Daniel