On 08/27/2015 10:46 AM, Ryan King - NOAA Affiliate wrote:
When attempting to create the required functions and extensions for the
MySQL FDW, I get the following errors:
dbname=# CREATE FUNCTION mysql_fdw_handler()
RETURNS fdw_handler
AS '$libdir/mysql_fdw'
LANGUAGE C STRICT;
ERROR: could not access file "$libdir/mysql_fdw": No such file or directory
dbname=# CREATE EXTENSION mysql_fdw;
ERROR: could not open extension control file
"/usr/pgsql-9.4/share/extension/mysql_fdw.control": No such file or
directory
What needs to be installed for this to work?
How did you install Postgres and/or mysql_fdw?
If from source I would say your are missing the make install step:
https://github.com/EnterpriseDB/mysql_fdw
http://pgxn.org/dist/mysql_fdw/
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general