From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Dane Foster <studdugie(at)gmail(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: mysql_fdw trouble |
Date: | 2015-10-29 17:56:10 |
Message-ID: | 56325DBA.1020907@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 10/29/2015 10:47 AM, Dane Foster wrote:
> Hello,
>
> I have a MySQL/PHP app that I want to port to PostgreSQL so I just
> installed the mysql_fdw from https://github.com/EnterpriseDB/mysql_fdw
> because I'd like to do the data migration in SQL if possible.
>
> Installation and set up worked flawlessly but when I run the following query
> SELECT
> title,
> description,
> '[' || starts || ', ' || COALESCE(ends, 'infinity') || ']'
> FROM
> _filler
> WHERE
> starts IS NOT NULL
> AND description IS NOT NULL
> AND LENGTH(TRIM(title)) > 0
> AND LENGTH(TRIM(description)) > 0;
>
> I get the following error:
>
>
> ERROR: failed to prepare the MySQL query:
> FUNCTION latest.btrim does not exist
>
> FYI: Tables names that start w/ _ are the MySQL versions of PostgreSQL
> tables.
>
>
> Any help would be appreciated.
What version of Postgres are you using?
>
> Thanks,
>
>
> Dane
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Dane Foster | 2015-10-29 17:57:57 | Re: mysql_fdw trouble |
Previous Message | Melvin Davidson | 2015-10-29 17:54:09 | Re: does pg_dump get delayed if I have a loop that does continuous insertions |