Thank you Andrew - the suggestion worked wonderfully!
Not being a pg Admin person (or even sql user), it took me a while to
determine that I could just open legacy.sql with a text editor, copy the
text, paste it into the pg Admin sql space, and execute the query.
I am a happy GeoNetworker now!
-----Original Message-----
From: andrew walsh [mailto:awalsh@anonymised.com]
Sent: September 26, 2012 5:09 PM
To: Curran, Terry
Cc: geonetwork-users@lists.sourceforge.net
Subject: Re: [GeoNetwork-users] GeonNetwork 2.8 RC1,PostgreSQL 9.2 and
PostGIS 2.0.1 problem
Hi Terry,
I had the same problem. I am running postgresql 9.1 with postgis 2.0 on
win xp.
Run C:\Program Files\PostgreSQL\9.1\share\contrib\postgis-2.0\legacy.sql
on your GN db. This will add some deprecated spatial functions that GN
still
uses. I run this through the pg Admin III tool.
HTH
Andrew
----- Original Message -----
From: "Curran, Terry" <Terry.Curran@anonymised.com>
To: <geonetwork-users@lists.sourceforge.net>
Sent: Thursday, September 27, 2012 9:44 AM
Subject: [GeoNetwork-users] GeonNetwork 2.8 RC1,PostgreSQL 9.2 and
PostGIS 2.0.1
problem
<<geonetwork.log>>
I cannot seem to get the three applications working together to use the
spatial indexing.
I can connect to PostgreSQL directly from GN, and independently the
connection between PostgreSQL and PostGIS also seems to work. I can
connect from GN to PostGIS okay which suggests the config.xml file is
okay.
I get an error when GN is booting related to a missing function
'asText("the_geom")'. I attach the log file. My operating system is
Windows7.
Someone has suggested I may need to load the "legacy.sql" functions? If
so, how?
Terry Curran