Re: Lookup Primary Key of Foreign Server's Table - Mailing list pgsql-general

From Chris Morris
Subject Re: Lookup Primary Key of Foreign Server's Table
Date
Msg-id CALrUc2Uw3-3fg3HpSe8Mpx9BL7me_YZhQ3LD-W1BdFZFfn+RZQ@mail.gmail.com
Whole thread Raw
In response to Re: Lookup Primary Key of Foreign Server's Table  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: Lookup Primary Key of Foreign Server's Table
List pgsql-general
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 CONSTRAINT command against the foreign table to reflect what is actually true in the foreign table? Is that correct?


pgsql-general by date:

Previous
From: Ravi Krishna
Date:
Subject: Is this a bug ?
Next
From: Ron
Date:
Subject: Re: Is this a bug ?