[Geoserver-devel] [jira] Created: (GEOS-1746) Versioning installation problems

Versioning installation problems
--------------------------------

                 Key: GEOS-1746
                 URL: http://jira.codehaus.org/browse/GEOS-1746
             Project: GeoServer
          Issue Type: Bug
          Components: PostGIS
    Affects Versions: 1.6.0
         Environment: Linux
            Reporter: Scot E. Wilcoxon
            Assignee: Andrea Aime

Only installation instructions seem to be within the Versioning download, in data_dir/README.txt.

1. Instructions do not state that "spearfish" database must be converted from PostgreSQL to PostGIS.
2. When converting to PostGIS with the lwpostgis.sql script errors occur:
...
CREATE FUNCTION
lwpostgis.sql:1257: ERROR: unterminated quoted string at or near "'

BEGIN

EXECUTE ''SET local search_path = ''||$2||'',public'';"
LINE 12: AS '
^
lwpostgis.sql:1258: ERROR: syntax error at or near "RETURN"
LINE 3: RETURN public.build_histogram2d($1,$3,$4);
^
... etc.

--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira