On Mon, Oct 5, 2009 at 4:47 PM, Rob Marjot <r...@marjot-multisoft.com> wrote: > Hi Rob(ert)! > Good idea! (but no luck) > It shows that it fetches some records from the table -- surprisingly this is > not a spatial query based on the bounding box of the initial view as it is > recorded in the mapinfo_mapcatalog table. Then, after fetching some 50 > records (out of 560), the last query is the following: > select c.relhasrules, c.relkind, c.relhasoids from pg_catalog.pg_namespace > u, pg_catalog.pg_class c > where u.oid = c.relnamespace and c.relname = E'dummy_table' and u.nspname > = E'public'
You might try with a different, maybe simpler, table. This might help you determine if you have a fundamental problem in your setup, or if maybe the 51st row in your table has an object that is causing problems. In MapInfo, I'd select the centroids, and attribute data from your table, and then load it into PostGIS, and then try your live connection. That way you're working with only point objects, but still working in the same coordinate system. Good luck, keep us posted. -- Richard Greenwood richard.greenw...@gmail.com www.greenwoodmap.com _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
