I tracked down the problem in the postgis datastore to the
getTypeNames() functions:

if (namespace != null && !namespace.trim().equals("")) { //$NON-NLS-1$
        st = conn.prepareStatement(
                "SELECT distinct a.relname "  //$NON-NLS-1$
                + "FROM pg_class a, pg_attribute b, pg_namespace c, pg_type d "
//$NON-NLS-1$
           + "WHERE a.oid = b.attrelid " //$NON-NLS-1$
                 + "AND b.atttypid = d.oid "  //$NON-NLS-1$
                 + "AND a.relnamespace = c.oid "  //$NON-NLS-1$
                 + "AND c.nspname = ? " //$NON-NLS-1$
                 + "AND d.typname = ? " //$NON-NLS-1$
                 + "AND a.relname in (SELECT f_table_name FROM 
geometry_columns)"
//$NON-NLS-1$
        );
        st.setString(1, namespace);
        st.setString(2, "geometry"); //$NON-NLS-1$
}

This assumes that the pg_namespace table is properly setup; which, I'm
sure, most people will not have.

Jody said he backed this change out.

dave





----------------------------------------------------------
This mail sent through IMP: https://webmail.limegroup.com/


-------------------------------------------------------
This SF.Net email is sponsored by:
Power Architecture Resource Center: Free content, downloads, discussions,
and more. http://solutions.newsforge.com/ibmarch.tmpl
_______________________________________________
Geotools-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geotools-devel

Reply via email to