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

[Qgis-user] DB Manager error with PostgreSQL 12

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