foreign key to foreign table

[Kaye Ann Ignacio]

Hi,

I have a foreign table created with postgres_fdw and with that, I tried to
create a local table to reference the foreign table in order to set a
foreign key constraint in my local table but I get an error message saying
that the referenced table is not a table. Is there a way I can reference a
foreign table?

Thank you.

-- 
Kaye Ann Ignacio, Programmer
proceedit "the BPaaS company"
kaye.igna...@proceedit.com +34 679188011 (mobile)

Add constraint in a Materialized View

[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...@proceedit.com +34 679188011 (mobile)