[mapguide-users] Fdo Provider PostGreSql 12

[Izhar Azati]

Maybe the word "TYPE" is a reserved word.

On Tue, May 18, 2021 at 12:18 AM Diego Ordonez <diordonezr at 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-bounces at lists.osgeo.org> on behalf
> of Gordon Luckett <gordon.luckett at arrowgeomatics.com>
> *Sent:* May 17, 2021 16:36
> *To:* MapGuide Users Mail List <mapguide-users at 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 <diordonezr at 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 at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/mapguide-users
>
> _______________________________________________
> mapguide-users mailing list
> mapguide-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/mapguide-users
>


-- 
*יזהר עזתי*
טרומפלדור 5
קרית אונו 5529505
izhar at azati.co.il
+972502066983
http://www.azati.co.il
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapguide-users/attachments/20210519/c18995d2/attachment.html>