Обсуждение: Problem with at_askml function in Postgis

Поиск
Список
Период
Сортировка

Problem with at_askml function in Postgis

От
"Hall, Samuel L (Sam)"
Дата:

Using PostgreSQL 9.1.8 on x86_64-unknown-linux-gnu, compiled by gcc (Ubuntu/Linaro 4.6.3-1ubuntu5) 4.6.3, 64-bit

POSTGIS="2.0.1 r9979" GEOS="3.3.3-CAPI-1.7.4" PROJ="Rel. 4.8.0, 6 March 2012" GDAL="GDAL 1.9.2, released 2012/10/08" LIBXML="2.8.0" LIBJSON="UNKNOWN" TOPOLOGY RASTER

 

Postgis seems to be working fine, but when I try this query

SELECT st_askml(path) FROM paths WHERE jobnumber = '20121491';

 

I get this error

ERROR:  function st_askml(geometry) is not unique

LINE 1: select st_askml(path) from paths where jobnumber = '20121491...

               ^

HINT:  Could not choose a best candidate function. You might need to add explicit type casts.

 

If I change the query to

SELECT st_askml(path,15) FROM paths WHERE jobnumber = '20121491';

 

Then it works

 

 

Both st_askml(geometry)  and st_askml(geometry, integer) are unique.

 

Does anybody know the answer to this problem?

Вложения

Re: Problem with at_askml function in Postgis

От
Tom Lane
Дата:
"Hall, Samuel L (Sam)" <sam.hall@alcatel-lucent.com> writes:
> I get this error
> ERROR:  function st_askml(geometry) is not unique
> LINE 1: select st_askml(path) from paths where jobnumber = '20121491...
>                ^
> HINT:  Could not choose a best candidate function. You might need to add explicit type casts.

> Both st_askml(geometry)  and st_askml(geometry, integer) are unique.

Perhaps st_askml(geometry, integer) has a default value for the integer
argument?  If so, the variant without that argument should have been
removed.  I'm suspicious that you've got some sort of upgrading glitch
that left both variants present when only one was needed.

            regards, tom lane