Postgres Pro
Downloads
Home   >   mailing lists

Re: mysql_fdw trouble - Mailing list pgsql-general

From Tom Lane
Subject Re: mysql_fdw trouble
Date
Msg-id 1656.1446141883@sss.pgh.pa.us
Whole thread Raw
In response to mysql_fdw trouble  (Dane Foster <studdugie@gmail.com>)
Responses Re: mysql_fdw trouble  (Dane Foster <studdugie@gmail.com>)
List pgsql-general
Tree view 
Dane Foster <studdugie@gmail.com> writes:
> Installation and set up worked flawlessly but when I run the following query
> ...
> ​I get the following error:​
> ​ERROR:  failed to prepare the MySQL query:
> FUNCTION latest.btrim does not exist

It looks like mysql_fdw is messing up by sending the trim() checks for
remote execution when there is no suitable function on the remote side.
Don't know whether that's a bug in mysql_fdw, or whether there's some
setup you're supposed to perform on the mysql server and have omitted.

            regards, tom lane

pgsql-general by date:

Previous
From: Dane Foster
Date:
Subject: Re: mysql_fdw trouble
Next
From: Adrian Klaver
Date:
Subject: Re: does pg_dump get delayed if I have a loop that does continuous insertions