[Geoserver-users] Geoserver 2.1.1 with postgis 2.0

GeoServer GeoServer User
1

Hi all,

i was using geoserver 2.1.1 with postgis 1.5 and every thing was ok.

Now i have updated my db server and postgis too, from 1.5 to 2.0.

I am trying to run the same layer, but i receive the following error:
Caused by: org.postgresql.util.PSQLException: ERROR: function geomfromwkb(bytea) does not exist
Hint: No function matches the given name and argument types. You might need to add explicit type casts.

I have noticed that geoserver 2.1.1 use geomfromwkb(bytea) that is deprecated in postgis 1.5 and therefore it has been deleted in postgis 2.0.

Is there some patch for geoserver 2.1.1, or do i have to upgrade geoserver to 2.3 version?

Thanks in advance,

Matteo.

2

Hi,

Run "legacy.sql" in PostGIS and you will get the old names for the functions back.

-Jukka Rahkonen-
________________________________
Matteo Cusmai wrote:

Hi all,

i was using geoserver 2.1.1 with postgis 1.5 and every thing was ok.
Now i have updated my db server and postgis too, from 1.5 to 2.0.

I am trying to run the same layer, but i receive the following error:

Caused by: org.postgresql.util.PSQLException: ERROR: function geomfromwkb(bytea) does not exist
  Hint: No function matches the given name and argument types. You might need to add explicit type casts.

I have noticed that geoserver 2.1.1 use geomfromwkb(bytea) that is deprecated in postgis 1.5 and therefore it has been deleted in postgis 2.0.

Is there some patch for geoserver 2.1.1, or do i have to upgrade geoserver to 2.3 version?

Thanks in advance,
Matteo.

3

Hi Jukka,
thanks a lot, it fixed my problem.

I was not able to find a solution by documentation.

···

On Mon, Mar 18, 2013 at 10:22 PM, Rahkonen Jukka <jukka.rahkonen@anonymised.com6…> wrote:

Hi,

Run “legacy.sql” in PostGIS and you will get the old names for the functions back.

-Jukka Rahkonen-

Matteo Cusmai wrote:

Hi all,
i was using geoserver 2.1.1 with postgis 1.5 and every thing was ok.
Now i have updated my db server and postgis too, from 1.5 to 2.0.

I am trying to run the same layer, but i receive the following error:
Caused by: org.postgresql.util.PSQLException: ERROR: function geomfromwkb(bytea) does not exist
Hint: No function matches the given name and argument types. You might need to add explicit type casts.

I have noticed that geoserver 2.1.1 use geomfromwkb(bytea) that is deprecated in postgis 1.5 and therefore it has been deleted in postgis 2.0.

Is there some patch for geoserver 2.1.1, or do i have to upgrade geoserver to 2.3 version?

Thanks in advance,
Matteo.