Maybe the word "TYPE" is a reserved word. On Tue, May 18, 2021 at 12:18 AM Diego Ordonez <diordon...@hotmail.com> wrote:
> 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/postgres@200.116.160.53_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 <mapguide-users-boun...@lists.osgeo.org> on behalf > of Gordon Luckett <gordon.luck...@arrowgeomatics.com> > *Sent:* May 17, 2021 16:36 > *To:* MapGuide Users Mail List <mapguide-users@lists.osgeo.org> > *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 <diordon...@hotmail.com> > 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 > mapguide-users@lists.osgeo.org > https://lists.osgeo.org/mailman/listinfo/mapguide-users > > _______________________________________________ > mapguide-users mailing list > mapguide-users@lists.osgeo.org > https://lists.osgeo.org/mailman/listinfo/mapguide-users > -- *יזהר עזתי* טרומפלדור 5 קרית אונו 5529505 iz...@azati.co.il +972502066983 http://www.azati.co.il
_______________________________________________ mapguide-users mailing list mapguide-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/mapguide-users