foreign key to foreign table

From: Kaye Ann Ignacio <kaye(dot)ignacio(at)proceedit(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: foreign key to foreign table
Date: 2018-07-17 06:43:03
Message-ID: CAHzfm1AqukX1WYtAdfLuTDKNpZRhuCeVxkMMoWj6Fo51Rh_4sg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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(dot)ignacio(at)proceedit(dot)com +34 679188011 (mobile)

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2018-07-17 06:46:32 Re: missing toast table for pg_policy
Previous Message Michael Paquier 2018-07-17 06:21:48 Re: Add SKIP LOCKED to VACUUM and ANALYZE