[OSGeoLive] problems with pgAdmin3 and PostgreSQL 10

[Johan Van de Wauw]

There are things happening at:
https://salsa.debian.org/postgresql/pgadmin4

and
https://www.postgresql.org/download/linux/ubuntu/

Kind Regards,
Johan

On Mon, Jun 18, 2018 at 4:13 PM, Angelos Tzotsos <gcpp.kalxas at gmail.com>
wrote:

> Thanks for the feedback Astrid.
> Lets see if pgadmin4 is available in Bionic...
>
> Cheers,
> Angelos
>
> On Mon, Jun 18, 2018 at 11:21 AM, Astrid Emde (OSGeo) <
> astrid_emde at osgeo.org> wrote:
>
>> Hello,
>>
>> Bionic offers PostgreSQL 10 and pgAdmin3.
>>
>> I noticed that pgAdmn3 has problems with PostgreSQL sequence
>> visualisation.
>>
>> When you click on a sequence you get an error and in the end pgAdmin
>> crashes.
>>
>> ERROR:  column "min_value" does not exist
>> LINE 1: SELECT last_value, min_value, max_value, cache_value, is_cyc...
>>
>>             ^
>> Reason is that the sequence information changed and that some columns do
>> not exist anymore.
>> user at user:/var/www/html/$ psql -U user natural_earth2
>> psql (10.4 (Ubuntu 10.4-0ubuntu0.18.04))
>> Type "help" for help.
>>
>> natural_earth2=# Select * from ne_10m_lakes_gid_seq;
>>  last_value | log_cnt | is_called
>> ------------+---------+-----------
>>        1343 |      10 | t
>>
>>
>> with PostgreSQl 9.x the table had a different columns
>> Select * from ne_10m_lakes_gid_seq;
>>     sequence_name     | last_value | start_value | increment_by |
>> max_value      | min_value | cache_value | log_cnt | is_cycled | is_called
>> ----------------------+------------+-------------+----------
>> ----+---------------------+-----------+-------------+-------
>> --+-----------+-----------
>>  ne_10m_lakes_gid_seq |       1343 |           1 |            1 |
>> 9223372036854775807 |         1 |           1 |       0 | f         | t
>> (1 row)
>>
>> Now my question is whether we should also offer pgAdmin4 with OSGeoLive?
>>
>> 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.
>>
>> Astrid
>>
>> --
>>
>> -------------------------------------------------------------
>> Astrid Emde
>> OSGeo Board Member and OSGeo Secretary
>> Open Source Geospatial Foundation
>> https://www.osgeo.org/member/astrid-emde/
>> astrid_emde at osgeo.org
>> _______________________________________________
>> osgeolive mailing list
>> osgeolive at lists.osgeo.org
>> https://lists.osgeo.org/mailman/listinfo/osgeolive
>>
>
>
>
> --
> Angelos Tzotsos, PhD
> OSGeo Charter Member
> http://users.ntua.gr/tzotsos
>
> _______________________________________________
> osgeolive mailing list
> osgeolive at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/osgeolive
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/osgeolive/attachments/20180618/ea7c1e30/attachment.html>