[Qgis-user] DB Manager error with PostgreSQL 12
Hi I just upgraded my database to PostgreSQL 12 and PostGIS 3.0. Since then I get an error when trying to load layers with the DB Manager: column adef.adsrc does not exist LINE 8: adef.adsrc AS default_value, However, loading through the browser works well and other clients do not seem to have a problem. I see that this issue has already been reported here: https://github.com/qgis/QGIS/issues/32321 I am not familiar enough with the Git workflow to be able to tell if this has been fixed and entered into the code, so that the problem is solved in the next release. If not, I would have to downgrade to PostgreSQL 11. Can anyone tell me what the status of the fix is? Thanks Árni Árni Geirsson *Alta ehf* // +354 582 5003 // +354 897 9549 ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] DB Manager error with PostgreSQL 12
This issue was fixed yesterday. On Sat, Nov 9, 2019, 19:35 Árni Geirsson wrote: > Hi > I just upgraded my database to PostgreSQL 12 and PostGIS 3.0. Since then I > get an error when trying to load layers with the DB Manager: > > column adef.adsrc does not exist > LINE 8: adef.adsrc AS default_value, > > However, loading through the browser works well and other clients do not > seem to have a problem. > I see that this issue has already been reported here: > https://github.com/qgis/QGIS/issues/32321 > I am not familiar enough with the Git workflow to be able to tell if this > has been fixed and entered into the code, so that the problem is solved in > the next release. If not, I would have to downgrade to PostgreSQL 11. Can > anyone tell me what the status of the fix is? > > Thanks > > Árni > > Árni Geirsson > *Alta ehf* // +354 582 5003 // +354 897 9549 > ___ > Qgis-user mailing list > Qgis-user@lists.osgeo.org > List info: https://lists.osgeo.org/mailman/listinfo/qgis-user > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] DB Manager error with PostgreSQL 12
Great, thanks! Árni Geirsson *Alta ehf* // +354 582 5003 // +354 897 9549 On Sat, 9 Nov 2019 at 19:02, Alessandro Pasotti wrote: > This issue was fixed yesterday. > > On Sat, Nov 9, 2019, 19:35 Árni Geirsson wrote: > >> Hi >> I just upgraded my database to PostgreSQL 12 and PostGIS 3.0. Since then >> I get an error when trying to load layers with the DB Manager: >> >> column adef.adsrc does not exist >> LINE 8: adef.adsrc AS default_value, >> >> However, loading through the browser works well and other clients do not >> seem to have a problem. >> I see that this issue has already been reported here: >> https://github.com/qgis/QGIS/issues/32321 >> I am not familiar enough with the Git workflow to be able to tell if this >> has been fixed and entered into the code, so that the problem is solved in >> the next release. If not, I would have to downgrade to PostgreSQL 11. Can >> anyone tell me what the status of the fix is? >> >> Thanks >> >> Árni >> >> Árni Geirsson >> *Alta ehf* // +354 582 5003 // +354 897 9549 >> ___ >> Qgis-user mailing list >> Qgis-user@lists.osgeo.org >> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user >> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user > > ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] linux qgis repo error
I'm getting this warning on updating Linux Mint: W: GPG error: https://qgis.org/debian xenial InRelease: The following signatures couldn't be verified because the public key is not available: NO_PUBKEY 51F523511C7028C3 W: The repository 'https://qgis.org/debian xenial InRelease' is not signed. Who is responsible for this? Thanks! d ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] linux qgis repo error
Hi Dave, On Sat, 09. Nov 2019 at 10:29:17 -0800, Dave Stevens wrote: > I'm getting this warning on updating Linux Mint: > W: GPG error: https://qgis.org/debian xenial InRelease: The following > signatures couldn't be verified because the public key is not > available: NO_PUBKEY 51F523511C7028C3 W: The repository > 'https://qgis.org/debian xenial InRelease' is not signed. > > Who is responsible for this? You ;) xenial is unsupported (Qt too old, w/o ubuntugis also GDAL). Try https://qgis.org/ubuntugis-ltr (see [0]) Jürgen [0] https://qgis.org/en/site/forusers/alldownloads.html#debian-ubuntu -- Jürgen E. Fischer norBIT GmbH Tel. +49-4931-918175-31 Dipl.-Inf. (FH) Rheinstraße 13 Fax. +49-4931-918175-50 Software Engineer D-26506 Nordenhttps://www.norbit.de QGIS release manager (PSC) GermanyIRC: jef on FreeNode signature.asc Description: PGP signature norBIT Gesellschaft fuer Unternehmensberatung und Informationssysteme mbH Rheinstrasse 13, 26506 Norden GF: Juergen Fischer, Nils Kutscher HR: Amtsgericht Aurich HRB 100827 Datenschutzerklaerung: https://www.norbit.de/83/ ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user