Re: foreign key to foreign table

2018-07-17 Thread Ashutosh Bapat
On Tue, Jul 17, 2018 at 12:13 PM, Kaye Ann Ignacio wrote: > 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

foreign key to foreign table

2018-07-17 Thread 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