[postgis-users] Live access to PostGIS from MapInfo
rob.marjot at gmail.com
Mon Oct 5 15:56:45 PDT 2009
Well, ODBC logging doesn't provide much information...
2009/10/6 InterRob <rob.marjot at 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 =
> 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...
> 2009/10/5 Robert Coup <robert.coup at onetrackmind.co.nz>
>> On Tue, Oct 6, 2009 at 9:16 AM, InterRob <rob.marjot at 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 :)
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the postgis-users