Postgres Pro
Downloads
Home   >   mailing lists

foreign key to foreign table - Mailing list pgsql-hackers

From Kaye Ann Ignacio
Subject foreign key to foreign table
Date
Msg-id CAHzfm1AqukX1WYtAdfLuTDKNpZRhuCeVxkMMoWj6Fo51Rh_4sg@mail.gmail.com
Whole thread Raw
Responses Re: foreign key to foreign table  (Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>)
List pgsql-hackers
Tree view
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.ignacio@proceedit.com +34 679188011 (mobile)

pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: Add SKIP LOCKED to VACUUM and ANALYZE
Next
From: Michael Paquier
Date:
Subject: Re: missing toast table for pg_policy