[postgis-users] Live access to PostGIS from MapInfo

[InterRob]

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 =
> "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.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...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20091006/1481e3a4/attachment.html>