Postgres Pro
Downloads
Home   >   mailing lists

Add constraint in a Materialized View - Mailing list pgsql-hackers

From Kaye Ann Ignacio
Subject Add constraint in a Materialized View
Date
Msg-id CAHzfm1D2s+P+DqEyZALvg-cNaH7q1NDBUOtBCF+8S_B3u-o_Fg@mail.gmail.com
Whole thread Raw
Responses Re: Add constraint in a Materialized View
List pgsql-hackers
Tree view
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.ignacio@proceedit.com +34 679188011 (mobile)

pgsql-hackers by date:

Previous
From: Craig Ringer
Date:
Subject: Re: [bug fix] Produce a crash dump before main() on Windows
Next
From: Konstantin Knizhnik
Date:
Subject: Re: [HACKERS] PATCH: multivariate histograms and MCV lists