Add constraint in a Materialized View

2018-07-20 Thread Kaye Ann Ignacio
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.igna...@pr

foreign key to foreign table

2018-07-17 Thread Kaye Ann Ignacio
a foreign table? Thank you. -- Kaye Ann Ignacio, Programmer proceedit "the BPaaS company" kaye.igna...@proceedit.com +34 679188011 (mobile)