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

[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 Files\QGIS
> 3.10\apps\qgis\python\plugins\db_manager\db_plugins\postgis
> 
> substitue
> *adef.adsrc*
> with
> *pg_get_expr(adbin,adrelid)*
> 
> and 
> substitue
> *c.consrc*
> with
> *c.conbin*
> 
> Regards,
> Hayati Tastan
> https://tr.linkedin.com/in/hayatitastan
>   
> 
> 
> 
> --
> Sent from: http://osgeo-org.1560.x6.nabble.com/QGIS-User-f4125267.html
> ___
> 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
> 

-- 
Paolo Cavallini - www.faunalia.eu
QGIS.ORG Chair:
http://planet.qgis.org/planet/user/28/tag/qgis%20board/
___
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

[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 
substitue
*c.consrc*
with
*c.conbin*

Regards,
Hayati Tastan
https://tr.linkedin.com/in/hayatitastan
  



--
Sent from: http://osgeo-org.1560.x6.nabble.com/QGIS-User-f4125267.html
___
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

[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 
substitue
*c.consrc*
with
*c.conbin*

Regards,
Hayati Tastan
https://tr.linkedin.com/in/hayatitastan
  




--
Sent from: http://osgeo-org.1560.x6.nabble.com/QGIS-User-f4125267.html
___
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

[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 
substitue
*c.consrc*
with
*c.conbin*

Regards,
Hayati Tastan
https://tr.linkedin.com/in/hayatitastan
  




--
Sent from: http://osgeo-org.1560.x6.nabble.com/QGIS-User-f4125267.html
___
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

[Á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. 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

[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 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

[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: 
> 
> 2016-10-28T15:58:35   1   Traceback (most recent call last):
> 
> File 
> "/usr/share/qgis/python/plugins/db_manager/db_model.py", 
line
> 440, in rowCount
> 
>   self._refreshIndex(parent, True)
> 
> File 
> "/usr/share/qgis/python/plugins/db_manager/db_model.py", 
line
> 491, in _refreshIndex
> 
>   if item.populate():
> 
> File 
> "/usr/share/qgis/python/plugins/db_manager/db_model.py", 
line
> 166, in populate
> 
>   if not connection.connect():
> 
> File
> "/usr/share/qgis/python/plugins/db_manager/db_plugins/postgis/plugin.py",
> line 99, in connect
> 
>   return self.connectToUri(uri)
> 
> File 
"/usr/share/qgis/python/plugins/db_manager/db_plugins/plugin.py",
> line 108, in connectToUri
> 
>   self.db = self.databasesFactory(self, uri)
> 
> File
> "/usr/share/qgis/python/plugins/db_manager/db_plugins/postgis/plugin.py",
> line 69, in databasesFactory
> 
>   return PGDatabase(connection, uri)
> 
> File
> "/usr/share/qgis/python/plugins/db_manager/db_plugins/postgis/plugin.py",
> line 107, in __init__
> 
>   Database.__init__(self, connection, uri)
> 
> File 
"/usr/share/qgis/python/plugins/db_manager/db_plugins/plugin.py",
> line 217, in __init__
> 
>   self.connector = self.connectorsFactory(uri)
> 
> File
> "/usr/share/qgis/python/plugins/db_manager/db_plugins/postgis/plugin.py",
> line 110, in connectorsFactory
> 
>   return PostGisDBConnector(uri)
> 
> File
> "/usr/share/qgis/python/plugins/db_manager/db_plugins/postgis/connector.py
> ", line 67, in __init__
> 
>   self.connection = 
psycopg2.connect(expandedConnInfo.encode('utf-8'))
> 
> File 
> "/usr/lib/python3/dist-packages/psycopg2/__init__.py", 
line 164,
> in connect
> 
>   conn = _connect(dsn, 
> connection_factory=connection_factory,
> async=async)
> 
>   TypeError: argument 1 must be str, not bytes
> 
> 
> I can load postgis layers from the same connection without problems.
> What can I do?

I see a pull request about that https://github.com/qgis/QGIS/pull/3635, but it 
is still tagged work in progress.

-- 
Spatialys - Geospatial professional services
http://www.spatialys.com
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user