Nothwithstanding the fact I had my x and y's around the wrong way, I've got it
working using ST_MakePoint.See below
On 25/07/2012, at 12:39 AM, Mark Wynter wrote:
> CREATE OR REPLACE FUNCTION load_xyz_data(sourcefile text, sourcesrid integer)
> RETURNS text AS $$
&
Notwithstanding the fact I had my x and y's around the wrong way, I've got it
working using ST_MakePoint.See below
On 25/07/2012, at 12:39 AM, Mark Wynter wrote:
> CREATE OR REPLACE FUNCTION load_xyz_data(sourcefile text, sourcesrid integer)
> RETURNS text AS $$
&
Within a pl/pgsql function block, I'm wanting to populate a geometry column
with x,y data. However when I invoke the function, I get the error message
that column "y" doesn't exist, even though it does.
The error message is:
SELECT load_xyz_data('/var/tmp/rscp_coverage_test.txt',32754);
ERROR:
I''m hoping someone can help me out. I'm wanting to run GRASS GIS from within
a plpythonu function block. But to run GRASS GIS externally, the following
environmental variables need to be available to the Postgresql server...
GISBASE='/usr/local/grass-6.4.3svn'
PATH='$PATH:$GISBASE/bin:$GISBA
