[postgis-users] Live access to PostGIS from MapInfo

[pcreso at pcreso.com]

Hi Rob,

I have not used Postgis with Mapinfo, but it sounds like it could be a permissions problem, or you did not run the spatial_ref_sys.sql file.

I'm making this guess as the error states that Mapinfo can't translate the spatial constraint, which is likely to mean unable to access the spatial_ref_sys table.

Just like you ran the postgis.sql file to install Postgis in your db, you need to run spatial_ref_sys.sql to create & populate the table with projection info.

If you have, or this doesn't fix the problem, it may be unable to access the table, even though it exists.

To remedy this, in your Postgis database, try running the SQL:

grant select on spatial_ref_sys to public;

This gives all users read access to the spatial_ref_sys table.


HTH,

  Brent Wood

--- On Mon, 10/5/09, InterRob <rob.marjot at gmail.com> wrote:

> From: InterRob <rob.marjot at gmail.com>
> Subject: [postgis-users] Live access to PostGIS from MapInfo
> To: "PostGIS Users Discussion" <postgis-users at postgis.refractions.net>
> Date: Monday, October 5, 2009, 10:06 PM
> Dear
> all,
> I hope some of you have experience with
> accessing PostGIS from MapInfo: I have some problems
> connecting to a spatial table residing in my PostGIS-enabled
> PostgreSQL database.
>
> What I did is the following:
> 1. created a dummy database and loaded
> postgis.sql (v. 1.4) into it2. within this
> database I created a MapInfo MapCatalog using
> EasyLoader
> 3. Then, I uploaded a small map (560 records)
> into the database, done in 3 secs :)
> So far, no errors.
> Lastly, I opened the table by clicking the
> "Open DBMS Table" button and whished to use the
> table in "Live Access" mode. When doing so,
> MapInfo produces the following error:
> "Unable to translate the Spatial
> Constraint."In case I check
> "Cache", MapInfo adds to this message: "File
> #nnnn not open for access."
> What does this mean? And more importantly: how
> to fix this? By the way: loading the PostgreSQL as a
> (downloaded) Linked Table works OK.
>
> By the way: does any of you have any experience
> with "Live Access"-ing a VIEW on a spatially
> enabled PostGIS table from MapInfo? In PostgreSQL no such
> thing as a *indexed view* exists, so will MapInfo be able to
> open such a VIEW?
>
>
> Thanks in advance for any help,
>
> Rob
>
> -----Inline Attachment Follows-----
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>