<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Thank you Jackie</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 decided to adventure with MG 4.00 and Ubuntu 16.04 x64</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Everything is working fine now.</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);">
Cheers</div>
<div>
<div id="appendonsend"></div>
<div style="font-family:Calibri,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" color="#000000" style="font-size:11pt"><b>From:</b> mapguide-users <mapguide-users-bounces@lists.osgeo.org> on behalf of Jackie Ng <jumpinjackie@gmail.com><br>
<b>Sent:</b> May 19, 2021 06:01<br>
<b>To:</b> mapguide-users@lists.osgeo.org <mapguide-users@lists.osgeo.org><br>
<b>Subject:</b> Re: [mapguide-users] Fdo Provider PostGreSql 12</font>
<div> </div>
</div>
<div>
<div dir="ltr">The adsrc column was removed in PostgreSQL 12 and so queries that list tables and views broke.
<div><br>
</div>
<div>This issue (<a href="https://trac.osgeo.org/fdo/ticket/973">https://trac.osgeo.org/fdo/ticket/973</a>) is actually fixed a long time ago in FDO 4.1 and a patched PostgreSQL provider dll is available for MGOS 3.1.2, but only for Windows.</div>
<div><br>
</div>
<div>For Linux, you will have to compile the PostgreSQL provider from source yourself on the latest FDO 4.1 branch.</div>
<div><br>
</div>
<div>- Jackie<br>
<div dir="ltr" class="x_gmail_signature">
<div dir="ltr">
<div></div>
</div>
</div>
<div><br>
</div>
<div>You wrote:</div>
<div><br>
</div>
<blockquote style="margin:0 0 0 40px; border:none; padding:0px">
<div>
<div style="font-family:Calibri,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
Hello there</div>
</div>
<div>
<div style="font-family:Calibri,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
</div>
<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>
<div>
<div style="font-family:Calibri,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
</div>
<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>
<div>
<div style="font-family:Calibri,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
</div>
<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>
<div>
<div style="font-family:Calibri,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
</div>
<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>
</div>
<div>
<div style="font-family:Calibri,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<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>
</div>
</div>
</blockquote>
</div>
<br clear="all">
<div><br>
</div>
-- <br>
<div dir="ltr" class="x_gmail_signature">
<div dir="ltr"><font size="1"><i>Please Note: I no longer create new posts or post replies to any OSGeo mailing list through nabble. As a result, you most likely won't see this message appear on nabble's view of any OSGeo mailing list and may only see this
message through mailing list archives or depending on your mailing list subscription settings, through daily message digests or automated notifications from the mailing lists.</i></font></div>
</div>
</div>
</div>
</div>
</body>
</html>