From: | Dane Foster <studdugie(at)gmail(dot)com> |
---|---|
To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: mysql_fdw trouble |
Date: | 2015-10-29 17:57:57 |
Message-ID: | CA+WxinJyBbrziSG7ugMjNfXYz7xO6+Jfnmf1n4oS=y_WzYHDRg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Thu, Oct 29, 2015 at 1:56 PM, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
wrote:
> 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
>
My bad. I should know better. It's PostgreSQL 9.5beta1 on
x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 4.9.2-10ubuntu13) 4.9.2, 64-bit
Thanks,
Dane
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2015-10-29 18:04:43 | Re: mysql_fdw trouble |
Previous Message | Adrian Klaver | 2015-10-29 17:56:10 | Re: mysql_fdw trouble |