On Wed, Jul 18, 2018 at 09:28:19AM +0200, Kaye Ann Ignacio wrote: > I'm trying to add a foreign constraint in my local table to reference a > column in a materialized view, is it possible to alter this materialized > view by adding a primary key constraint?
It's not, but I'm working on a patch for that and much more. Basically, I want to integrate something like https://github.com/twosigma/postgresql-contrib/blob/master/mat_views.sql I currently use that code instead of PG native materialized views. Nico --
