Search Postgresql Archives

Re: PostgreSQL 9.5, mysql_fdw, and IMPORT FOREIGN SCHEMA question

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 01/08/2016 08:45 PM, Deven Phillips 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..

Yes, dbname is a required option to FOREIGN TABLE:

https://github.com/EnterpriseDB/mysql_fdw
"The following parameters can be set on a MySQL foreign table object:

dbname: Name of the MySQL database to query. This is a mandatory option."


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.phillips@xxxxxxxxx <mailto:deven.phillips@xxxxxxxxx>> 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.klaver@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx>> 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.klaver@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx>





--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux