[postgis-users] Live access to PostGIS from MapInfo

[InterRob]

Hi Brent,
Thank you for your reply. In fact, I did indeed run spatial_ref_sys.sql --
otherwise addgeometrycolumn() wouldn't even run in the first place; I forgot
to list the script :))
Thus, as you suggested, I tried grant-ing access to spatial_ref_sys (as well
as the target table...); it didn't help, unfortunately.

By the way, accessing the table as a "Linked Table" (effectively downloading
the complete table, converting it to native MapInfo), DOES work. However,
this doesn't fit to my usage scenario... I guess that shouldn't surprise too
many of you :))

More thoughts? Cheerz,


Rob

2009/10/5 Brent Wood <pcreso at yahoo.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
> >
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20091005/18627975/attachment.html>