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
