[postgis-users] Live access to PostGIS from MapInfo

[InterRob]

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/58492c87/attachment.html>