[postgis-users] php query problem "AsText(table.geometry)", multiple schemas

[Andreas Neumann]

ok, i found it out by myself:

I had to add the schema-name containing the postgis functions before the 
function name, something like:

public.AsText(mytable.thegeom)

It works fine now in three different schemas. It seems that pgadminIII 
automatically looked for functions in all three schemas, while php wouldn't.

Sorry about disturbing you,

Andreas


Patricio Cifuentes Ithal wrote:

>all the functions and data must be in the same scheme
>  
>


-- 
----------------------------------------------
Andreas Neumann
Institute of Cartography
ETH Zurich
Wolfgang-Paulistrasse 15
CH-8093  Zurich, Switzerland

Phone: ++41-44-633 3031, Fax: ++41-44-633 1153
e-mail: neumann at karto.baug.ethz.ch
www: http://www.carto.net/neumann/
SVG.Open: http://www.svgopen.org/
Carto.net: http://www.carto.net/