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'
This query is valid and produces one row: my table has NO RULES (column value = "f"), is a PLAIN TABLE (value = "r") and has NO OIDs (value = "f")... Curiously, this last query seems to have little to do with any "Spatial Constraint" (as is MapInfo complaining about) So, still no clue here... Maybe something can be deducted from the logs of the pgsqlODBC... Rob 2009/10/5 Robert Coup <robert.c...@onetrackmind.co.nz> > On Tue, Oct 6, 2009 at 9:16 AM, InterRob <rob.mar...@gmail.com> wrote: > > > > More thoughts? Cheerz, > > Try looking in the postgresql logs - it should log errors all the > time, and you can turn on log_statement=all in postgresql.conf to see > everything (turn it off once you're done though). > > That might give you a bit of insight into what MapInfo is asking for / > not getting. > > Rob :) > >
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
