Yeah. Part of my confusion is due to Heroku providing a Data Links service
that handles a lot of the internal details around establishing a
foreign server connection, and not knowing exactly what to expect.
I experimented with IMPORT FOREIGN SCHEMA in a couple of test databases and
noticed that th
On Wed, Oct 23, 2019 at 8:47 AM Chris Morris
wrote:
> The foreign table has a primary key. Ruby on Rails uses a system query to
> lookup what the primary key on the table is, but it's querying the local
> database, and not finding anything. In a schema dump of the local database,
> I don't see a
The foreign table has a primary key. Ruby on Rails uses a system query to
lookup what the primary key on the table is, but it's querying the local
database, and not finding anything. In a schema dump of the local database,
I don't see a primary key defined, so I'm presuming I need to issue an ADD
C
On Tue, Oct 22, 2019 at 9:16 AM Chris Morris
wrote:
> I'm looking for a system query that will lookup the primary key column on
> a fdw table. It's possible we need to declare that part of the foreign
> table's schema in the local (is that the right term?) database?
>
> Here's the foreign table -
I'm looking for a system query that will lookup the primary key column on a
fdw table. It's possible we need to declare that part of the foreign
table's schema in the local (is that the right term?) database?
Here's the foreign table - I don't see anything showing a primary key, so
my hunch is we
