[mapguide-users] Fdo Provider PostGreSql 12

[Diego Ordonez]

Thank you Jackie

I decided to adventure with MG 4.00 and Ubuntu 16.04 x64
Everything is working fine now.

Cheers

________________________________
From: mapguide-users <mapguide-users-bounces at lists.osgeo.org> on behalf of Jackie Ng <jumpinjackie at gmail.com>
Sent: May 19, 2021 06:01
To: mapguide-users at lists.osgeo.org <mapguide-users at lists.osgeo.org>
Subject: Re: [mapguide-users] Fdo Provider PostGreSql 12

The adsrc column was removed in PostgreSQL 12 and so queries that list tables and views broke.

This issue (https://trac.osgeo.org/fdo/ticket/973) 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.

For Linux, you will have to compile the PostgreSQL provider from source yourself on the latest FDO 4.1 branch.

- Jackie

You 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...


--
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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapguide-users/attachments/20210519/624535a5/attachment.html>