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 <[email protected]> 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) < > [email protected]> 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@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/ >> [email protected] >> _______________________________________________ >> osgeolive mailing list >> [email protected] >> https://lists.osgeo.org/mailman/listinfo/osgeolive >> > > > > -- > Angelos Tzotsos, PhD > OSGeo Charter Member > http://users.ntua.gr/tzotsos > > _______________________________________________ > osgeolive mailing list > [email protected] > https://lists.osgeo.org/mailman/listinfo/osgeolive > >
_______________________________________________ osgeolive mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/osgeolive
