Re: mysql_fdw trouble

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