[jira] Created: (DNA-21) First build of PostGIS module of GeoTools2. Needed to load geometry_columns table?

Message:

  A new issue has been created in JIRA.

---------------------------------------------------------------------
View the issue:

  http://jira.codehaus.org/secure/ViewIssue.jspa?key=DNA-21


Here is an overview of the issue:
---------------------------------------------------------------------
        Key: DNA-21
    Summary: First build of PostGIS module of GeoTools2. Needed to load geometry_columns table?
       Type: Wish

     Status: Unassigned
   Priority: Major

 Original Estimate: 30 minutes
 Time Spent: Unknown
  Remaining: 30 minutes

    Project: dna
 Components: 
             API
   Versions:
             2.0

   Assignee: 
   Reporter: 

    Created: Tue, 25 Nov 2003 11:25 AM
    Updated: Tue, 25 Nov 2003 11:25 AM
Environment: Java 1.4.1

Description:
Hi,

The first build of the GeoTools2 is almost OK except that of PostGIS.
This is module that I am most interested in.
By doing "maven test" in PostgisTest.java (excluding all other tests) only.

I am getting the following console message excerpt
.....
    [junit] 25/11/2003 11:03:39 org.geotools.data.postgis.PostgisTest setUp
    [junit] INFO: exception while making schemaCouldn't make schema: org.geotool
s.data.DataSourceException:  no geometry found in the GEOMETRY_COLUMNS table  fo
r jdbc_test of the postgis install.  A row for geom is required   for geotools t
o work correctly
    [junit] 25/11/2003 11:03:39 org.geotools.data.postgis.PostgisTest testMaxFea
tures
    [junit] INFO: ...threw data source exceptionorg.geotools.data.DataSourceExce
ption: Couldn't make schema: org.geotools.data.DataSourceException:  no geometry
 found in the GEOMETRY_COLUMNS table  for jdbc_test of the postgis install.  A r
ow for geom is required   for geotools to work correctly
......

I installed PostGreSQL/PostGIS correctly and tested with the accompanying sample of the PostGIS
and it worked perfectly. Now I am wondering if any additional sql script is needed to load into PostGre, besides postgis.sql,
in order to make the GeoTools run properly.

I guess that the table geometry_columns must be loaded. So, is there any standard procedure for doing that?
Do I need to run the samples tests in some specified order?

SinceI am a rookie in the field the automatic successful test of the postgis is very helpful for our learning and a good starter.

thanks a lot
Carlos



---------------------------------------------------------------------
JIRA INFORMATION:
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

If you want more information on JIRA, or have a bug to report see:
   http://www.atlassian.com/software/jira