Re: mysql_fdw trouble

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.klaver@aklaver.com