Hi,
I am using postgresql9.4.2 for linux and want to create spatial type in db.I have put st_geometory.so in postgresql's library directory.But when create spatial type,there is a error that is
"You must copy the latest ST_GEOMETRY library to the PostgreSQL software location. Refer to the ArcGIS help topics for more details.
Connected RDBMS instance is not setup for Esri spatial type configuration.
Failed to execute".
And I find a error log that is "ERROR: could not load library "/home/gpadmin/gpdb/lib/postgresql/st_geometry.so": /home/gpadmin/gpdb/lib/postgresql/st_geometry.so: undefined symbol: Float8GetDatum (dfmgr.c:240)".so I test command ld -v st_geometry.so, show result like this:
ld: warning: cannot find entry symbol _start; not setting start address
st_geometry.so: undefined reference to `elog_finish'
st_geometry.so: undefined reference to `pstrdup'
st_geometry.so: undefined reference to `pq_getmsgbytes'
st_geometry.so: undefined reference to `errstart'
st_geometry.so: undefined reference to `SPI_tuptable'
st_geometry.so: undefined reference to `pfree'
st_geometry.so: undefined reference to `get_attstatsslot'
st_geometry.so: undefined reference to `CurrentMemoryContext'
st_geometry.so: undefined reference to `ReleaseSysCache'
st_geometry.so: undefined reference to `SPI_fname'
st_geometry.so: undefined reference to `errfinish'
st_geometry.so: undefined reference to `dlsym'
st_geometry.so: undefined reference to `SearchSysCache'
st_geometry.so: undefined reference to `Float8GetDatum'
st_geometry.so: undefined reference to `elog_start'
st_geometry.so: undefined reference to `SPI_execute_with_args'
st_geometry.so: undefined reference to `SPI_getvalue'
st_geometry.so: undefined reference to `pq_endtypsend'
st_geometry.so: undefined reference to `SPI_finish'
st_geometry.so: undefined reference to `list_nth'
st_geometry.so: undefined reference to `SPI_connect'
st_geometry.so: undefined reference to `repalloc'
st_geometry.so: undefined reference to `pq_begintypsend'
st_geometry.so: undefined reference to `errmsg'
st_geometry.so: undefined reference to `free_attstatsslot'
st_geometry.so: undefined reference to `DatumGetFloat8'
st_geometry.so: undefined reference to `pg_qsort'
st_geometry.so: undefined reference to `pq_sendbytes'
st_geometry.so: undefined reference to `palloc'
st_geometry.so: undefined reference to `errcode'
st_geometry.so: undefined reference to `pq_copymsgbytes'
st_geometry.so: undefined reference to `SPI_exec'
st_geometry.so: undefined reference to `SPI_processed'
st_geometry.so: undefined reference to `default_statistics_target'
st_geometry.so: undefined reference to `DirectFunctionCall1Coll'
st_geometry.so: undefined reference to `dlopen'
st_geometry.so: undefined reference to `DirectFunctionCall2Coll'
st_geometry.so: undefined reference to `errhint'
st_geometry.so: undefined reference to `pg_detoast_datum'
st_geometry.so: undefined reference to `vacuum_delay_point'
st_geometry.so: undefined reference to `dlclose'
st_geometry.so: undefined reference to `MemoryContextAlloc'
Is the file of st_geometry.so not compatible for my system？My OS is centos 7 1611.
how to fix it？Thanks！！
