Hi Gordon No I'm trying to read a table, and permissions are OK because I use the postgres user
MapGuide Server is Centos 6 x64 System.Exception: The remote server returned an error: (559) MgFdoException.: An exception occurred in FDO component. Error occurred in Feature Source (Library://Ejemplo_Neiva/Data/[email protected]_10654 (12 Test).FeatureSource): RDBMS: [PGRES_FATAL_ERROR] ERROR: column d.adsrc does not exist LINE 1: ...name AS table_name, c.attname AS name, 1 AS type, d.adsrc as... ^ (Cause: RDBMS: [PGRES_FATAL_ERROR] ERROR: column d.adsrc does not exist LINE 1: ...name AS table_name, c.attname AS name, 1 AS type, d.adsrc as... ^ , Root Cause: RDBMS: [PGRES_FATAL_ERROR] ERROR: column d.adsrc does not exist LINE 1: ...name AS table_name, c.attname AS name, 1 AS type, d.adsrc as... ^ ) - MgFeatureServiceHandler.ProcessOperation() line 83 file FeatureServiceHandler.cpp - MgOpDescribeSchemaAsXml.Execute() line 110 file OpDescribeSchemaAsXml.cpp - MgServerFeatureService.DescribeSchemaAsXml() line 381 file ServerFeatureService.cpp - MgServerDescribeSchema.DescribeSchemaAsXml() line 647 file ServerDescribeSchema.cpp - MgServerDescribeSchema.DescribeSchema() line 583 file ServerDescribeSchema.cpp - MgServerDescribeSchema.DescribeFdoSchema() line 217 file ServerDescribeSchema.cpp ---> System.Net.WebException: The remote server returned an error: (559) MgFdoException. at System.Net.HttpWebRequest.GetResponse() at OSGeo.MapGuide.MaestroAPI.HttpServerConnection.OpenRead(String req) in C:\projects\mapguide-maestro\OSGeo.MapGuide.MaestroAPI\Http\HttpServerConnection.cs:line 1405 ________________________________ From: mapguide-users <[email protected]> on behalf of Gordon Luckett <[email protected]> Sent: May 17, 2021 16:36 To: MapGuide Users Mail List <[email protected]> Subject: Re: [mapguide-users] Fdo Provider PostGreSql 12 Are you trying to look at a view? It looks like one of the tables on the view is not accessable to the login user.. On Mon, May 17, 2021, 9:14 PM Diego Ordonez <[email protected]<mailto:[email protected]>> wrote: Hello there I have MapGUIDE 3.1.2 on Centos 6 x64 Everything seems to work properly, except connecting a layer to Postgresql 12 How do I set up FDO 4.1 properly ? RDBMS: [PGRES_FATAL_ERROR] ERROR: column d.adsrc does not exist LINE 1: ...name AS table_name, c.attname AS name, 1 AS type, d.adsrc as... _______________________________________________ mapguide-users mailing list [email protected]<mailto:[email protected]> https://lists.osgeo.org/mailman/listinfo/mapguide-users
_______________________________________________ mapguide-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/mapguide-users
