<div dir="ltr"><div class="gmail_extra">There are things happening at:</div><div class="gmail_extra"><a href="https://salsa.debian.org/postgresql/pgadmin4">https://salsa.debian.org/postgresql/pgadmin4</a><br></div><div class="gmail_extra"><br></div><div class="gmail_extra">and</div><div class="gmail_extra"><a href="https://www.postgresql.org/download/linux/ubuntu/">https://www.postgresql.org/download/linux/ubuntu/</a><br></div><div class="gmail_extra"><br></div><div class="gmail_extra">Kind Regards,</div><div class="gmail_extra">Johan</div><div class="gmail_extra"><br><div class="gmail_quote">On Mon, Jun 18, 2018 at 4:13 PM, Angelos Tzotsos <span dir="ltr"><<a href="mailto:gcpp.kalxas@gmail.com" target="_blank">gcpp.kalxas@gmail.com</a>></span> wrote:<br><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">Thanks for the feedback Astrid.<div>Lets see if pgadmin4 is available in Bionic...</div><div><br></div><div>Cheers,</div><div>Angelos</div></div><div class="gmail_extra"><div><div class="gmail-h5"><br><div class="gmail_quote">On Mon, Jun 18, 2018 at 11:21 AM, Astrid Emde (OSGeo) <span dir="ltr"><<a href="mailto:astrid_emde@osgeo.org" target="_blank">astrid_emde@osgeo.org</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Hello,<br>
<br>
Bionic offers PostgreSQL 10 and pgAdmin3.<br>
<br>
I noticed that pgAdmn3 has problems with PostgreSQL sequence visualisation.<br>
<br>
When you click on a sequence you get an error and in the end pgAdmin crashes.<br>
<br>
ERROR: column "min_value" does not exist<br>
LINE 1: SELECT last_value, min_value, max_value, cache_value, is_cyc...<br>
<br>
^<br>
Reason is that the sequence information changed and that some columns do not exist anymore.<br>
user@user:/var/www/html/$ psql -U user natural_earth2<br>
psql (10.4 (Ubuntu 10.4-0ubuntu0.18.04))<br>
Type "help" for help.<br>
<br>
natural_earth2=# Select * from ne_10m_lakes_gid_seq;<br>
last_value | log_cnt | is_called<br>
------------+---------+-------<wbr>----<br>
1343 | 10 | t<br>
<br>
<br>
with PostgreSQl 9.x the table had a different columns<br>
Select * from ne_10m_lakes_gid_seq;<br>
sequence_name | last_value | start_value | increment_by | max_value | min_value | cache_value | log_cnt | is_cycled | is_called<br>
----------------------+-------<wbr>-----+-------------+----------<wbr>----+---------------------+---<wbr>--------+-------------+-------<wbr>--+-----------+-----------<br>
ne_10m_lakes_gid_seq | 1343 | 1 | 1 | 9223372036854775807 | 1 | 1 | 0 | f | t<br>
(1 row)<br>
<br>
Now my question is whether we should also offer pgAdmin4 with OSGeoLive?<br>
<br>
What do you think about the idea? Do you know why still pgAdmin3 is provided with bionic and not pgAdmin4? Maybe pgAdmin4 brings other problems and usability is not so good? But maybe it is good to offer both and have the choice.<span class="gmail-m_-5629673698447370356HOEnZb"><font color="#888888"><br>
<br>
Astrid<br>
<br>
-- <br>
<br>
------------------------------<wbr>------------------------------<wbr>-<br>
Astrid Emde<br>
OSGeo Board Member and OSGeo Secretary<br>
Open Source Geospatial Foundation<br>
<a href="https://www.osgeo.org/member/astrid-emde/" rel="noreferrer" target="_blank">https://www.osgeo.org/member/a<wbr>strid-emde/</a><br>
<a href="mailto:astrid_emde@osgeo.org" target="_blank">astrid_emde@osgeo.org</a><br>
______________________________<wbr>_________________<br>
osgeolive mailing list<br>
<a href="mailto:osgeolive@lists.osgeo.org" target="_blank">osgeolive@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/osgeolive" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailma<wbr>n/listinfo/osgeolive</a><br>
</font></span></blockquote></div><br><br clear="all"><div><br></div></div></div><span class="gmail-HOEnZb"><font color="#888888">-- <br><div class="gmail-m_-5629673698447370356gmail_signature"><div dir="ltr"><div><span style="border-collapse:separate;color:rgb(0,0,0);font-family:"Times New Roman";font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:-webkit-auto;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;font-size:medium"><span style="font-family:arial;font-size:small">Angelos Tzotsos, PhD<br>OSGeo Charter Member<div><a href="http://users.ntua.gr/tzotsos" target="_blank">http://users.ntua.gr/tzotsos</a></div></span></span></div></div></div>
</font></span></div>
<br>______________________________<wbr>_________________<br>
osgeolive mailing list<br>
<a href="mailto:osgeolive@lists.osgeo.org">osgeolive@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/osgeolive" rel="noreferrer" target="_blank">https://lists.osgeo.org/<wbr>mailman/listinfo/osgeolive</a><br>
<br></blockquote></div><br></div></div>