From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Melpati, Muni Sent: 28 June 2012 21:19 To: postgis-users@postgis.refractions.net Subject: [postgis-users] Problem with using query layer in ArcGIS 10
Hi I was querying posgis layers from ArcGIS 10. I found that if add postgis layer with huge number of records, I am having trouble with accessing its attributes. When I try to open the table I get "Could not load data from the data source. If you can correct the problem, press the refresh button to reload data. Possible problems can include bad network connection, invalid field, etc. The SQL statement was not a select statement. The operation is not supported by this implementation." I found similar problem somewhere in GIS forums where the user had to change the MAXBLOBSIZE value to -1 (unlimited) in the SDE SERVER CONFIG FILE. Is there similar fix to postgis/postgres? I appreciate your support. Thanks. By default ArcGIS uses all the fields in the query as the unique key. Tools such as identify labeling and the attribute table do not work when this is the case. To make them work the primary key of the data source should be used as the unique key. This also speeds up the loading of data. After writing a query, you need to click the Validate button and tick "Show advanced options". The Next button will now be highlighted - click it. Uncheck all fields in the Unique identifier fields list except the correct primary key or unique field. The attribute table should now work if you provided a unique key. HTH, Will Temperley
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users