<div dir="ltr"><div>Hi,</div><div><br></div><div>One breaking change I'm aware of in QGIS 4 is that we've used the `CREATE TABLE IF NOT EXISTS` idiom for the `qgis_projects` table (for storing projects in the database) which was introduced in PostgreSQL 9.1</div><div><br></div><div>Best,</div><div>Stefanos</div></div><br><div class="gmail_quote gmail_quote_container"><div dir="ltr" class="gmail_attr">On Tue, 31 Mar 2026 at 15:55, Even Rouault via QGIS-Developer <<a href="mailto:qgis-developer@lists.osgeo.org">qgis-developer@lists.osgeo.org</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"><u></u>
<div>
<p>Carlo,</p>
<p>you're conflating two different things:</p>
<p>- PostgreSQL & PostGIS version support in GDAL. It might
still semi work for you with dropped supported version by
chance/accident.</p>
<p>- PostgreSQL & PostGIS version support in QGIS PostgreSQL
provider. Looking quickly at git log, I don't see anything
explicit abut dropping them. I suppose that support for those
older versions broke by accident or wasn't explicitly mentionned. </p>
<p>In any case those ancient versions aren't supported, have likely
unfixed security issues, and it would be hard for us to test
against them.</p>
<p>So use older QGIS versions if you really need to stick with your
ancient PostgreSQL & PostGIS version. There's hardly no chance
you can convince us (at least me for the code I'm responsible of)
to bring back support for them</p>
<p>Even</p>
<div>Le 31/03/2026 à 14:44, Carlo A.
Bertelli (Charta s.r.l.) via QGIS-Developer a écrit :<br>
</div>
<blockquote type="cite">
<div dir="ltr">
<div>
<div class="gmail_default" style="font-family:arial,sans-serif;font-size:small">I
understand that GDAL declares</div>
<blockquote style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex" class="gmail_quote"><span style="color:rgb(64,64,64);font-family:Lato,proxima-nova,"Helvetica Neue",Arial,sans-serif;font-size:16px;background-color:rgb(252,252,252)">Starting
with GDAL 3.9, only PostgreSQL >= 9 and PostGIS >= 2
are supported.</span></blockquote>
<div class="gmail_default" style="font-family:arial,sans-serif;font-size:small">but
version 3.44 still can open layers from a v. 8.4 database
and PostGIS 1.5.</div>
<div class="gmail_default" style="font-family:arial,sans-serif;font-size:small">Now
version 4 does not open layers from this database.</div>
<div class="gmail_default" style="font-family:arial,sans-serif;font-size:small">GDAL v.
3.12.3 per se can open these layers, ogrinfo works well,
ogr2ogr lets me upload data from files to the same database.</div>
<div class="gmail_default" style="font-family:arial,sans-serif;font-size:small">What
happened with the new version? I cannot even change
parameters per table. Is there a solution for this?</div>
<div class="gmail_default" style="font-family:arial,sans-serif;font-size:small">Unfortunately
I cannot change the database nor upgrade it, even if I would
like very much.</div>
<div class="gmail_default" style="font-family:arial,sans-serif;font-size:small">c</div>
</div>
<div><br>
</div>
<span class="gmail_signature_prefix">-- </span><br>
<div dir="ltr" class="gmail_signature">--------------------------------------------------------------------------<br>
Carlo A. Bertelli<br>
Charta servizi e sistemi per il territorio e la storia
ambientale srl <br>
Dipendenze del palazzo Doria, <br>
vc. alla Chiesa della Maddalena 9/2 16124
Genova (Italy)<br>
tel./fax +39(0)10 2475439 +39 0108566195
<a>mobile:+39</a> 393 1590711<br>
e-mail: <a href="mailto:bertelli@chartasrl.eu" target="_blank">bertelli@chartasrl.eu</a>
<a href="http://www.chartasrl.eu" target="_blank">http://www.chartasrl.eu</a><br>
--------------------------------------------------------------------------<br>
<br>
<br>
<br>
</div>
</div>
<br>
<fieldset></fieldset>
<pre>_______________________________________________
QGIS-Developer mailing list
<a href="mailto:QGIS-Developer@lists.osgeo.org" target="_blank">QGIS-Developer@lists.osgeo.org</a>
List info: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-developer" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-developer</a>
Unsubscribe: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-developer" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-developer</a>
</pre>
</blockquote>
<pre cols="72">--
<a href="http://www.spatialys.com" target="_blank">http://www.spatialys.com</a>
My software is free, but my time generally not.</pre>
</div>
_______________________________________________<br>
QGIS-Developer mailing list<br>
<a href="mailto:QGIS-Developer@lists.osgeo.org" target="_blank">QGIS-Developer@lists.osgeo.org</a><br>
List info: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-developer" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-developer</a><br>
Unsubscribe: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-developer" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-developer</a><br>
</blockquote></div>