Re: [Qgis-user] DB Manager error with PostgreSQL 12

2019-12-20 Thread Paolo Cavallini
this has already been reported and fixed. Please upgrade. cheers. Il 20/12/19 14:28, haytastan ha scritto: > PROBLEM: > > column adef.adsrc does not exist > LINE 8: adef.adsrc AS default_value, > > > SOLUTION: > > In the python file *connector.py * > in the diroctory > C:\Program

Re: [Qgis-user] DB Manager error with PostgreSQL 12

2019-12-20 Thread haytastan
PROBLEM: column adef.adsrc does not exist LINE 8: adef.adsrc AS default_value, SOLUTION: In the python file *connector.py * in the diroctory C:\Program Files\QGIS 3.10\apps\qgis\python\plugins\db_manager\db_plugins\postgis substitue *adef.adsrc* with *pg_get_expr(adbin,adrelid)* and

Re: [Qgis-user] DB Manager error with PostgreSQL 12

2019-12-20 Thread haytastan
PROBLEM: column adef.adsrc does not exist LINE 8: adef.adsrc AS default_value, SOLUTION: In the python file *connector.py * in the diroctory C:\Program Files\QGIS 3.10\apps\qgis\python\plugins\db_manager\db_plugins\postgis substitue *adef.adsrc* with *pg_get_expr(adbin,adrelid)* and

Re: [Qgis-user] DB Manager error with PostgreSQL 12

2019-12-20 Thread haytastan
PROBLEM: column adef.adsrc does not exist LINE 8: adef.adsrc AS default_value, SOLUTION: In the python file *connector.py * in the directory C:\Program Files\QGIS 3.10\apps\qgis\python\plugins\db_manager\db_plugins\postgis substitue *adef.adsrc* with *pg_get_expr(adbin,adrelid)* and

Re: [Qgis-user] DB Manager error with PostgreSQL 12

2019-11-09 Thread Árni Geirsson
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.

Re: [Qgis-user] DB Manager error with PostgreSQL 12

2019-11-09 Thread Alessandro Pasotti
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

[Qgis-user] DB Manager error with PostgreSQL 12

2019-11-09 Thread Árni Geirsson
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

Re: [Qgis-user] DB manager error

2016-10-29 Thread Even Rouault
Le vendredi 28 octobre 2016 21:09:26, vous avez écrit : > Hi, > > I'm using QGIS 2.99.0-Master rev. b2587b7 on Ubuntu 16.04 64bits. > > When I tried to open a SQL query on a POSTGIS database I've got the > following error while trying to open the saved connection to the > database: > >

[Qgis-user] DB manager error

2016-10-28 Thread Gustavo Martínez
Hi,  I'm using QGIS 2.99.0-Master rev. b2587b7 on Ubuntu 16.04 64bits. When I tried to open a SQL query on a POSTGIS database I've got the following error while trying to open the saved connection to the database:  2016-10-28T15:58:35 1 Traceback (most recent call last):