From: | Deven Phillips <deven(dot)phillips(at)gmail(dot)com> |
---|---|
To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: PostgreSQL 9.5, mysql_fdw, and IMPORT FOREIGN SCHEMA question |
Date: | 2016-01-09 04:50:55 |
Message-ID: | CAJw+4NDeSv8dbhohWxgCtOBZDpBTU58Vttq-N+tc8OBsEHayuA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Additional details. The MySQL server I am targeting is running
version 5.1.73. Perhaps it's too old of a version to support foreign schema
import?
Deven
On Fri, Jan 8, 2016 at 11:45 PM, Deven Phillips <deven(dot)phillips(at)gmail(dot)com>
wrote:
> I DID get a foreign table to work using the following:
>
> CREATE FOREIGN TABLE customer (
> id BIGINT,
> name VARCHAR(150),
> parent_id BIGINT,
> oracle_id BIGINT,
> last_updated_time TIMESTAMP,
> created_time TIMESTAMP) SERVER mysql OPTIONS (dbname 'mydb', table_name
> 'customer');
>
> And I was subsequently able to query that table from PostgreSQL..
>
> I tried to add the "OPTIONS" to the IMPORT FOREIGN SCHEMA and got an error
> that "dbname" is not a valid parameter.
>
> Thanks,
>
> Deven
>
> On Fri, Jan 8, 2016 at 11:38 PM, Deven Phillips <deven(dot)phillips(at)gmail(dot)com>
> wrote:
>
>> Apparently not, though I have done so in the past on PostgreSQL 9.4. It
>> appears to be related to the "schema" with which the foreign table is
>> associated:
>>
>> mydb=# CREATE FOREIGN TABLE customer (
>> id BIGINT,
>> name VARCHAR(150),
>> parent_id BIGINT,
>> oracle_id BIGINT,
>> last_updated_time TIMESTAMP,
>> created_time TIMESTAMP) SERVER mysql;
>> CREATE FOREIGN TABLE
>> mydb=# SELECT * FROM customer;
>> ERROR: failed to prepare the MySQL query:
>> Table 'public.customer' doesn't exist
>>
>> Any suggestions would be greatly appreciated!
>>
>> Deven
>>
>>
>> On Fri, Jan 8, 2016 at 10:26 AM, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com
>> > wrote:
>>
>>> On 01/08/2016 07:04 AM, Deven Phillips wrote:
>>>
>>>> Hi all,
>>>>
>>>> I installed the newly released PostgreSQL 9.5 this morning and
>>>> compiled the latest mysql_fdw extension from EnterpriseDB. I was able to
>>>> create the SERVER and USER MAPPING, but I cannot seem to get IMPORT
>>>> FOREIGN SCHEMA to do anything. The command executes without error, but
>>>> none of the table schemas are imported from the MySQL DB. Does anyone
>>>> have any advice, links, documentation which might be of help?
>>>>
>>>
>>> Can you CREATE FOREIGN TABLE and use it?
>>>
>>>
>>>> Thanks in advance!
>>>>
>>>> Deven
>>>>
>>>
>>>
>>> --
>>> Adrian Klaver
>>> adrian(dot)klaver(at)aklaver(dot)com
>>>
>>
>>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Deven Phillips | 2016-01-09 05:06:34 | Re: PostgreSQL 9.5, mysql_fdw, and IMPORT FOREIGN SCHEMA question |
Previous Message | Deven Phillips | 2016-01-09 04:45:50 | Re: PostgreSQL 9.5, mysql_fdw, and IMPORT FOREIGN SCHEMA question |