[postgis-users] Error in accessing a Postgis database - function box3d(box3d_extent) is not unique

Tue May 31 08:23:28 PDT 2011

I am using ArcGIS with the Data Interoperabilty Extension to access a
Postgis database and I get the following error: Error executing SQL query
('SELECT BOX3D(extent("the_geom")) FROM

"mdb"."PROV2011_proposed"'): 'ERROR:  function box3d(box3d_extent) is not
unique

LINE 1: SELECT BOX3D(extent("the_geom")) FROM "mdb"."PROV2011_propos...
               ^
HINT:  Could not choose a best candidate function. You might need to add
explicit type casts.

Below is the complete log:

2011-05-31 16:55:26|   0.1|  0.0|INFORM|Data Interoperability (20101013 -
Build 6233 - WIN32)
2011-05-31 16:55:26|   0.1|  0.0|INFORM|Feature Manipulation Engine 2010 SP3
(ESRI DESKTOP) (Build 6233)
2011-05-31 16:56:38|  10.7| 10.6|INFORM|Loaded module 'POSTGIS' from file
'C:\Program Files (x86)\ESRI\Data Interoperability
Extension\plugins/postgis/POSTGIS.dll'
2011-05-31 16:56:38|  10.7|  0.0|INFORM|FME API version of module 'POSTGIS'
matches current internal version (3.6 20090807)
2011-05-31 16:56:38|  10.7|  0.0|INFORM|Opening POSTGIS reader for dataset
'geodb'
2011-05-31 16:56:43|  12.0|  1.3|INFORM|PostgreSQL 8.4.8 on
x86_64-pc-linux-gnu, compiled by GCC gcc-4.5.real (Ubuntu/Linaro
4.5.2-8ubuntu4) 4.5.2, 64-bit
2011-05-31 16:56:43|  12.0|  0.0|INFORM|1.5 USE_GEOS=1 USE_PROJ=1
USE_STATS=1
2011-05-31 16:56:45|  12.0|  0.0|INFORM|PostGIS client encoding: 'LATIN1'
2011-05-31 16:56:45|  12.0|  0.0|INFORM|Using Dynamic Reader $Revision:
62876 $ ( $Date: 2009-08-27 11:28:55 -0700 (Thu, 27 Aug 2009) $ ) with
module POSTGIS to read data from dataset `geodb'
2011-05-31 16:56:48|  12.0|  0.0|INFORM|Reading POSTGIS table:
'mdb.PROV2011_proposed'...
2011-05-31 16:56:51|  13.3|  1.3|INFORM|FME Configuration: Source coordinate
system for reader R_1[POSTGIS] set to `EPSG:4326' as read from input data
2011-05-31 16:56:54|  15.5|  2.2|INFORM|Coordinate System `EPSG:4326'
parameters: CS_NAME=`LL84' DESC_NM=`WGS84 datum, Latitude-Longitude;
Degrees' DT_NAME=`WGS84' EPSG=`4326' GROUP=`LL' MAP_SCL=`1' PROJ=`LL'
QUAD=`1' SCL_RED=`1' SOURCE=`Mentor Software' UNIT=`DEGREE'
2011-05-31 16:56:54|  15.5|  0.0|INFORM|Coordinate System `EPSG:4326' as OGC
Well Known Text: GEOGCS["WGS84 datum, Latitude-Longitude;
Degrees",DATUM["WGS_1984",SPHEROID["World Geodetic System of 1984, GEM
10C",6378137,298.257223563,AUTHORITY["EPSG","7030"]],AUTHORITY["EPSG","6326"]],PRIMEM["Greenwich",0],UNIT["degree",0.0174532925199433],AUTHORITY["EPSG","4326"]]
2011-05-31 16:56:54|  15.6|  0.1|INFORM|FME API version of module 'POSTGIS'
matches current internal version (3.6 20090807)
2011-05-31 16:56:54|  15.6|  0.0|INFORM|Opening POSTGIS reader for dataset
'geodb'
2011-05-31 16:56:54|  15.6|  0.0|INFORM|PostgreSQL 8.4.8 on
x86_64-pc-linux-gnu, compiled by GCC gcc-4.5.real (Ubuntu/Linaro
4.5.2-8ubuntu4) 4.5.2, 64-bit
2011-05-31 16:56:54|  15.6|  0.0|INFORM|1.5 USE_GEOS=1 USE_PROJ=1
USE_STATS=1
2011-05-31 16:56:54|  15.6|  0.0|INFORM|PostGIS client encoding: 'LATIN1'
2011-05-31 16:56:54|  15.6|  0.0|INFORM|Successfully closed POSTGIS database
reader
2011-05-31 16:56:54|  15.6|  0.0|INFORM|Merged 1 schema features read from 1
datasets into 1 resulting feature types
2011-05-31 16:57:04|  17.0|  1.3|ERROR |Error executing SQL query ('SELECT
BOX3D(extent("the_geom")) FROM "mdb"."PROV2011_proposed"'): 'ERROR:
 function box3d(box3d_extent) is not unique
LINE 1: SELECT BOX3D(extent("the_geom")) FROM "mdb"."PROV2011_propos...
               ^
HINT:  Could not choose a best candidate function. You might need to add
explicit type casts.
'
2011-05-31 16:57:05|  17.2|  0.2|INFORM|Reading POSTGIS table:
'mdb.PROV2011_proposed'...
2011-05-31 16:57:09|  20.2|  3.0|STATS
|POSTGIS::__CollectionTest(TestFactory): Tested 10 input feature(s) -- 0
feature(s) passed and 10 feature(s) failed
2011-05-31 16:57:09|  20.2|  0.0|STATS
|POSTGIS::__DeaggCollections(DeaggregateFactory): Split 0 input feature(s)
into 0 point-in-polygon feature(s), 0 donut polygon(s), 0 polygon(s), 0
line(s), 0 point(s), and 0 aggregate(s)
2011-05-31 16:57:09|  20.2|  0.0|STATS
|POSTGIS::__AggregateHomo(AggregateFactory): Combined 0 input feature(s)
into 0 output feature(s), including 0 singleton(s)
2011-05-31 16:57:14|  20.6|  0.5|INFORM|Reading POSTGIS table:
'mdb.PROV2011_proposed'...
2011-05-31 16:57:51|  33.9| 13.2|INFORM|... Last line repeated 10 times ...
2011-05-31 16:57:51|  33.9|  0.0|INFORM|Loaded module 'fmeprompter' from
file 'fmeprompter.dll'
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20110531/037d04bd/attachment.html>