https://issues.qgis.org/https://issues.qgis.org/favicon.ico2018-12-23T00:49:35ZQGIS Issue TrackingQGIS Application - Bug report #20872: QGIS 3.5 not loading or saving multi-dimensional arrays properly from PostGIS layershttps://issues.qgis.org/issues/20872?journal_id=974112018-12-23T00:49:35ZCory Albrecht
<ul></ul><p>On loading the layer, the Qt messages windows displays lines like the following;</p>
<pre>
2018-12-22T19:48:10 WARNING Cannot find separator: },{es,"Nueva España"}
2018-12-22T19:48:10 WARNING Error parsing array: {es,"Virreinato de la Nueva España"},{es,"Nueva España"}
2018-12-22T19:48:10 WARNING Cannot find separator: }
2018-12-22T19:48:10 WARNING Error parsing array: {en,"Viceroyalty of New Spain"}</pre> QGIS Application - Bug report #20872: QGIS 3.5 not loading or saving multi-dimensional arrays properly from PostGIS layershttps://issues.qgis.org/issues/20872?journal_id=974152018-12-23T18:17:08ZCory Albrecht
<ul></ul><p>I just tried 3.4.2 and the issue is there, too.</p> QGIS Application - Bug report #20872: QGIS 3.5 not loading or saving multi-dimensional arrays properly from PostGIS layershttps://issues.qgis.org/issues/20872?journal_id=974162018-12-23T19:19:45ZCory Albrecht
<ul></ul><p>Here is what the feature attributes dialog looks like in 2,18.25 for the same feature object.<br /><img src="https://i.ibb.co/JdnWm4c/Screenshot-from-2018-12-23-14-14-27.png" alt="" /></p> QGIS Application - Bug report #20872: QGIS 3.5 not loading or saving multi-dimensional arrays properly from PostGIS layershttps://issues.qgis.org/issues/20872?journal_id=982752019-01-17T03:02:29ZCory Albrecht
<ul></ul><p>Ping.</p> QGIS Application - Bug report #20872: QGIS 3.5 not loading or saving multi-dimensional arrays properly from PostGIS layershttps://issues.qgis.org/issues/20872?journal_id=982812019-01-17T10:26:42ZGiovanni Manghigiovanni.manghi@gmail.com
<ul><li><strong>Priority</strong> changed from <i>Normal</i> to <i>High</i></li><li><strong>Regression?</strong> changed from <i>No</i> to <i>Yes</i></li></ul> QGIS Application - Bug report #20872: QGIS 3.5 not loading or saving multi-dimensional arrays properly from PostGIS layershttps://issues.qgis.org/issues/20872?journal_id=993252019-01-30T13:25:16ZJulien Cabiecesjulien.cabieces@oslandia.com
<ul><li><strong>Assignee</strong> set to <i>Julien Cabieces</i></li></ul> QGIS Application - Bug report #20872: QGIS 3.5 not loading or saving multi-dimensional arrays properly from PostGIS layershttps://issues.qgis.org/issues/20872?journal_id=994112019-01-31T14:56:33ZJulien Cabiecesjulien.cabieces@oslandia.com
<ul><li><strong>Pull Request or Patch supplied</strong> changed from <i>No</i> to <i>Yes</i></li></ul><p>Proposed PR : <a class="external" href="https://github.com/qgis/QGIS/pull/9048">https://github.com/qgis/QGIS/pull/9048</a></p> QGIS Application - Bug report #20872: QGIS 3.5 not loading or saving multi-dimensional arrays properly from PostGIS layershttps://issues.qgis.org/issues/20872?journal_id=1011552019-03-03T17:49:35ZCory Albrecht
<ul></ul><p>Still happening in 3.45, 3.60 and 3.7</p> QGIS Application - Bug report #20872: QGIS 3.5 not loading or saving multi-dimensional arrays properly from PostGIS layershttps://issues.qgis.org/issues/20872?journal_id=1011562019-03-03T17:49:56ZGiovanni Manghigiovanni.manghi@gmail.com
<ul><li><strong>Affected QGIS version</strong> changed from <i>3.5(master)</i> to <i>3.7(master)</i></li></ul> QGIS Application - Bug report #20872: QGIS 3.5 not loading or saving multi-dimensional arrays properly from PostGIS layershttps://issues.qgis.org/issues/20872?journal_id=1012012019-03-04T13:02:01ZJulien Cabiecesjulien.cabieces@oslandia.com
<ul></ul><blockquote>
<p>Still happening in 3.45, 3.60 and 3.7</p>
</blockquote>
<p>Proposed PR isn't accepted yep.</p> QGIS Application - Bug report #20872: QGIS 3.5 not loading or saving multi-dimensional arrays properly from PostGIS layershttps://issues.qgis.org/issues/20872?journal_id=1012502019-03-05T08:35:45ZJulien Cabiecesjulien.cabieces@oslandia.com
<ul><li><strong>Status</strong> changed from <i>Open</i> to <i>Closed</i></li><li><strong>% Done</strong> changed from <i>0</i> to <i>100</i></li></ul><p>Applied in changeset <a class="changeset" href="https://issues.qgis.org/projects/qgis/repository/revisions/0753b144b92763b18021f1d706a1cf184323b1aa" title="fixes #20872 : Manage postgres multidimensionnal array">qgis|0753b144b92763b18021f1d706a1cf184323b1aa</a>.</p> QGIS Application - Bug report #20872: QGIS 3.5 not loading or saving multi-dimensional arrays properly from PostGIS layershttps://issues.qgis.org/issues/20872?journal_id=1032162019-03-18T23:15:33ZCory Albrecht
<ul></ul><p>Julien Cabieces wrote:</p>
<blockquote>
<p>Applied in changeset <a class="changeset" href="https://issues.qgis.org/projects/qgis/repository/revisions/0753b144b92763b18021f1d706a1cf184323b1aa" title="fixes #20872 : Manage postgres multidimensionnal array">qgis|0753b144b92763b18021f1d706a1cf184323b1aa</a>.</p>
</blockquote>
<p>When will this be in a nightly? I just tried 3.7 and it's not there yet.</p> QGIS Application - Bug report #20872: QGIS 3.5 not loading or saving multi-dimensional arrays properly from PostGIS layershttps://issues.qgis.org/issues/20872?journal_id=1032442019-03-20T07:46:00ZJulien Cabiecesjulien.cabieces@oslandia.com
<ul><li><strong>File</strong> <a href="/attachments/download/14637/scr_table.png">scr_table.png</a> added</li><li><strong>File</strong> <a href="/attachments/download/14635/scr_rqst.png">scr_rqst.png</a> added</li><li><strong>File</strong> <a href="/attachments/download/14636/scr_form.png">scr_form.png</a> added</li></ul><p>Here is some screenshots with current master</p>
<p><img src="https://issues.qgis.org/attachments/download/14635/scr_rqst.png" alt="" /></p>
<p><img src="https://issues.qgis.org/attachments/download/14637/scr_table.png" alt="" /></p>
<p><img src="https://issues.qgis.org/attachments/download/14636/scr_form.png" alt="" /></p>
<p>Does it look like what you're seeing on your version of QGIS?</p>
<p>Could you please check the QGIS version once launched in the help > About dialog.</p> QGIS Application - Bug report #20872: QGIS 3.5 not loading or saving multi-dimensional arrays properly from PostGIS layershttps://issues.qgis.org/issues/20872?journal_id=1033152019-03-21T15:12:40ZCory Albrecht
<ul></ul><p>Julien Cabieces wrote:</p>
<blockquote>
<p>Does it look like what you're seeing on your version of QGIS?</p>
</blockquote>
<p>I did not use the new list widget, just the plain old text widget, as shown in my screencaps.</p>
<p>Any text representation that the psql command-line client uses to either show the results of a query, or how one might type in the command by hand as a raw SQL, one should be able to simply copy-paste back and forth between a terminal and QGIS in either the Feature Attribute form's plain text widget or in the Attribute Table columns.</p>
<p>That way all possible PostGIS data types have some kind of minimal support, and special widgets can wait until somebody has the inclination and time to write them.</p>
<blockquote>
<p>Could you please check the QGIS version once launched in the help > About dialog.</p>
</blockquote>
<p>Whatever was in the PPA <a class="external" href="https://qgis.org/ubuntu-nightly">https://qgis.org/ubuntu-nightly</a> Monday afternoon and evening, but I reverted to 3.6. I will check whatever is in the PPA once I get home from work.</p> QGIS Application - Bug report #20872: QGIS 3.5 not loading or saving multi-dimensional arrays properly from PostGIS layershttps://issues.qgis.org/issues/20872?journal_id=1033302019-03-22T07:40:47ZJulien Cabiecesjulien.cabieces@oslandia.com
<ul><li><strong>Status</strong> changed from <i>Closed</i> to <i>Reopened</i></li></ul><p>I see, there is an additionnal issue when we use the plain text display (the list widget is working by the way).</p>
<p>I reopen the ticket, and I'll try to find a way to correct this.</p> QGIS Application - Bug report #20872: QGIS 3.5 not loading or saving multi-dimensional arrays properly from PostGIS layershttps://issues.qgis.org/issues/20872?journal_id=1033322019-03-22T09:34:32ZJulien Cabiecesjulien.cabieces@oslandia.com
<ul></ul><p>Proposed PR : <a class="external" href="https://github.com/qgis/QGIS/pull/9610">https://github.com/qgis/QGIS/pull/9610</a></p>
<p>Be aware that there is still a problem to deal with integer and float array in plain text.</p>