Dane Foster <studdugie(at)gmail(dot)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