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 <pcr...@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.mar...@gmail.com> wrote: > > > From: InterRob <rob.mar...@gmail.com> > > Subject: [postgis-users] Live access to PostGIS from MapInfo > > To: "PostGIS Users Discussion" <postgis-users@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@postgis.refractions.net > > http://postgis.refractions.net/mailman/listinfo/postgis-users > > > >
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
