Well, ODBC logging doesn't provide much information... 2009/10/6 InterRob <rob.mar...@gmail.com>
> 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
