Add constraint in a Materialized View

From: Kaye Ann Ignacio <kaye(dot)ignacio(at)proceedit(dot)com>
To: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Add constraint in a Materialized View
Date: 2018-07-18 07:28:19
Message-ID: CAHzfm1D2s+P+DqEyZALvg-cNaH7q1NDBUOtBCF+8S_B3u-o_Fg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

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?

Thank you.

--
Kaye Ann Ignacio, Programmer
proceedit "the BPaaS company"
kaye(dot)ignacio(at)proceedit(dot)com +34 679188011 (mobile)

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Konstantin Knizhnik 2018-07-18 07:32:06 Re: [HACKERS] PATCH: multivariate histograms and MCV lists
Previous Message Craig Ringer 2018-07-18 07:17:24 Re: [bug fix] Produce a crash dump before main() on Windows