<div dir="ltr">Maybe the word "TYPE" is a reserved word.<br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Tue, May 18, 2021 at 12:18 AM Diego Ordonez <<a href="mailto:diordonezr@hotmail.com">diordonezr@hotmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div dir="ltr">
<div style="font-family:Calibri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
Hi Gordon</div>
<div style="font-family:Calibri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
<br>
</div>
<div style="font-family:Calibri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
No I'm trying to read a table, and permissions are OK because I use the postgres user </div>
<div style="font-family:Calibri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
<br>
</div>
<div style="font-family:Calibri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
MapGuide Server is Centos 6 x64</div>
<div style="font-family:Calibri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
<br>
</div>
<div style="font-family:Calibri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
System.Exception: The remote server returned an error: (559) MgFdoException.:
<div>An exception occurred in FDO component.</div>
<div>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</div>
<div>LINE 1: ...name AS table_name, c.attname AS name, 1 AS type, d.adsrc as...</div>
<div> ^</div>
<div> (Cause: RDBMS: [PGRES_FATAL_ERROR] ERROR: column d.adsrc does not exist</div>
<div>LINE 1: ...name AS table_name, c.attname AS name, 1 AS type, d.adsrc as...</div>
<div> ^</div>
<div>, Root Cause: RDBMS: [PGRES_FATAL_ERROR] ERROR: column d.adsrc does not exist</div>
<div>LINE 1: ...name AS table_name, c.attname AS name, 1 AS type, d.adsrc as...</div>
<div> ^</div>
<div>)</div>
<div><br>
</div>
<div>- MgFeatureServiceHandler.ProcessOperation() line 83 file FeatureServiceHandler.cpp</div>
<div>- MgOpDescribeSchemaAsXml.Execute() line 110 file OpDescribeSchemaAsXml.cpp</div>
<div>- MgServerFeatureService.DescribeSchemaAsXml() line 381 file ServerFeatureService.cpp</div>
<div>- MgServerDescribeSchema.DescribeSchemaAsXml() line 647 file ServerDescribeSchema.cpp</div>
<div>- MgServerDescribeSchema.DescribeSchema() line 583 file ServerDescribeSchema.cpp</div>
<div>- MgServerDescribeSchema.DescribeFdoSchema() line 217 file ServerDescribeSchema.cpp</div>
<div><br>
</div>
<div> ---> System.Net.WebException: The remote server returned an error: (559) MgFdoException.</div>
<div> at System.Net.HttpWebRequest.GetResponse()</div>
at OSGeo.MapGuide.MaestroAPI.HttpServerConnection.OpenRead(String req) in C:\projects\mapguide-maestro\OSGeo.MapGuide.MaestroAPI\Http\HttpServerConnection.cs:line 1405<br>
</div>
<div style="font-family:Calibri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
<br>
</div>
<div style="font-family:Calibri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
<br>
</div>
<div>
<div id="gmail-m_578416933554119549appendonsend"></div>
<div style="font-family:Calibri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
<br>
</div>
<hr style="display:inline-block;width:98%">
<div id="gmail-m_578416933554119549divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" color="#000000" style="font-size:11pt"><b>From:</b> mapguide-users <<a href="mailto:mapguide-users-bounces@lists.osgeo.org" target="_blank">mapguide-users-bounces@lists.osgeo.org</a>> on behalf of Gordon Luckett <<a href="mailto:gordon.luckett@arrowgeomatics.com" target="_blank">gordon.luckett@arrowgeomatics.com</a>><br>
<b>Sent:</b> May 17, 2021 16:36<br>
<b>To:</b> MapGuide Users Mail List <<a href="mailto:mapguide-users@lists.osgeo.org" target="_blank">mapguide-users@lists.osgeo.org</a>><br>
<b>Subject:</b> Re: [mapguide-users] Fdo Provider PostGreSql 12</font>
<div> </div>
</div>
<div>
<div dir="auto">Are you trying to look at a view?
<div dir="auto">It looks like one of the tables on the view is not accessable to the login user..</div>
</div>
<br>
<div>
<div dir="ltr">On Mon, May 17, 2021, 9:14 PM Diego Ordonez <<a href="mailto:diordonezr@hotmail.com" target="_blank">diordonezr@hotmail.com</a>> wrote:<br>
</div>
<blockquote style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div dir="ltr">
<div style="font-family:Calibri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
Hello there</div>
<div style="font-family:Calibri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
<br>
</div>
<div style="font-family:Calibri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
I have MapGUIDE 3.1.2 on <u>Centos 6 x64</u></div>
<div style="font-family:Calibri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
<br>
</div>
<div style="font-family:Calibri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
Everything seems to work properly, except connecting a layer to Postgresql 12</div>
<div style="font-family:Calibri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
<br>
</div>
<div style="font-family:Calibri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
How do I set up FDO 4.1 properly ?</div>
<div style="font-family:Calibri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
<br>
</div>
<div style="font-family:Calibri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
<br>
</div>
<div style="font-family:Calibri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
<span style="font-family:Consolas,Courier,monospace"><b>RDBMS: [PGRES_FATAL_ERROR] ERROR: column d.adsrc does not exist</b></span>
<div><span style="font-family:Consolas,Courier,monospace"><b>LINE 1: ...name AS table_name, c.attname AS name, 1 AS type, d.adsrc as...</b></span></div>
<br>
</div>
</div>
_______________________________________________<br>
mapguide-users mailing list<br>
<a href="mailto:mapguide-users@lists.osgeo.org" rel="noreferrer" target="_blank">mapguide-users@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/mapguide-users" rel="noreferrer noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/mapguide-users</a><br>
</blockquote>
</div>
</div>
</div>
</div>
_______________________________________________<br>
mapguide-users mailing list<br>
<a href="mailto:mapguide-users@lists.osgeo.org" target="_blank">mapguide-users@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/mapguide-users" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/mapguide-users</a><br>
</blockquote></div><br clear="all"><div><br></div>-- <br><div dir="rtl" class="gmail_signature"><div dir="ltr"><div style="text-align:right" dir="rtl"><b>יזהר עזתי</b></div><div style="text-align:right" dir="rtl">טרומפלדור 5</div><div style="text-align:right" dir="rtl">קרית אונו 5529505</div><div style="text-align:right"><a href="mailto:izhar@azati.co.il" target="_blank">izhar@azati.co.il</a></div><div style="text-align:right">+972502066983</div><div style="text-align:right"><a href="http://www.azati.co.il" target="_blank">http://www.azati.co.il</a><br></div></div></div>