Re: [Qgis-user] DB manager PostGIS import fails for strange reason

Hi! Thanks to a tip in this thread, I have been able to confirm that the table actually contains multipart polygons. So the error message is right, and since the first found feature is multipart, the import fails immediately. If I select only the single part features, the import runs with no

Re: [Qgis-user] DB manager PostGIS import fails for strange reason

Hi Mats, Several times I had to deal with this kind of problem and I found that the plugin GeomAttribute can be useful to find a faulty entity in a table. Maybe it could help you. https://philipwhitten.github.io/geomAttribute/html/pluginTools/geomAttribute.html Btw, I have the feeling that the

Re: [Qgis-user] DB manager PostGIS import fails for strange reason

Hi again! Andrea Giudiceandrea responded :"*it seems to me the error message says the contrary: you are trying to import MultiPolygon geometries in a Polygon column geom type table.*" Well I am not sure about that. It may be a semantic matter. The PostGIS table is non-existent at the time of

Re: [Qgis-user] DB manager PostGIS import fails for strange reason

*Mats Elfström* /Tue Jul 26 02:31:29 PDT 2022/ *PostGIS error while adding features: ERROR: Geometry type (MultiPolygon) does not match column type (Polygon)* a MultiPolygon table should anyway be able to accept single

[Qgis-user] DB manager PostGIS import fails for strange reason

Hi! This regards QGIS version 3.26.0-Buenos Aires. Attempting to import a gpkg poly layer to PostGIS I get this unexpected error. *Error 6* *Feature write errors:* *Creation error for features from #-9223372036854775808 to #-9223372036854775808. Provider errors was: * *PostGIS error while

[Qgis-user] DB Manager Attach another SQLite database

Hi, The SQL-Command ATTACH DATABASE 'c:\xxx\yyy.sqlite' doesn't work in the QGIS DBManager (and also not in the layer context menue). The command *does* work in python plugins. Is there another method in the DB Manager to transfer data from a table from one database to another? Best wishes

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

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

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

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

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 query: Can't get CASE WHEN to work

Ok, sorry for the noise! comma missing after select * SQL and me not going to be good friends Cheers, Bernd Am 07.12.19 um 18:47 schrieb Bernd Vogelgesang: Hi, maybe it's again some strange local issue, but I can't find a way to make CASE WHEN working in a DB Manger query or in a Vitual

[Qgis-user] DB Manager query: Can't get CASE WHEN to work

Hi, maybe it's again some strange local issue, but I can't find a way to make CASE WHEN working in a DB Manger query or in a Vitual Layer. The example is analog to https://www.sqlitetutorial.net/sqlite-case/ I would like to populate a new column "category" in that select SELECT * CASE WHEN

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.

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

[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

Re: [Qgis-user] DB Manager:"Load as new layer" query from point data returns invisible poylgon layer

Hi, it seems that my project was somehow broken. After a while zooming out froze the application. After setting up everything from zero, the "Load as new layer" button works as expected. Great! Big "but": When such a layer (is it a virtual layer?) is present in the project, I can't edit the

[Qgis-user] DB Manager: Different results from query in DB Manager and in Virtual Layer

Hi, I have a point dataset with nesting boxes (443) and a non-spatial table from QField where I filled in the already controlled nesting boxes. Now trying to find out which bixes are still need to be controlled. To filter the already boxes, I use this query SELECT "Birdboxes_GTA_20190316".*

Re: [Qgis-user] DB Manager:"Load as new layer" query from point data returns invisible poylgon layer

Hi Alessandro, forgot to mention that I'm on 3.6.2 on Linux Mint. At the moment I have no running instance of master, so I can't check if it is resolved there. Added sth to https://issues.qgis.org/issues/21675 Cheers, Bernd Am 29.04.19 um 14:11 schrieb Alessandro Pasotti: On Mon, Apr 29,

Re: [Qgis-user] DB Manager:"Load as new layer" query from point data returns invisible poylgon layer

On Mon, Apr 29, 2019 at 2:00 PM Bernd Vogelgesang wrote: > Hi, > > maybe I miss something obvious, but I can't manage to produce a new > point layer from a query in the DB Manager from a point dataset (First > time going this route, and very old sql-knowledge only). > > The query runs fine, I

[Qgis-user] DB Manager:"Load as new layer" query from point data returns invisible poylgon layer

Hi, maybe I miss something obvious, but I can't manage to produce a new point layer from a query in the DB Manager from a point dataset (First time going this route, and very old sql-knowledge only). The query runs fine, I see the results, but when I hit the "Load as new layer"-button, it adds

Re: [Qgis-user] DB Manager cannot connect to PostGIS (error with traceback)

thanks Luigi! 2018-03-20 16:59 GMT+01:00 Luigi Pirelli : > working on that... seems Boundless master repo remained to november > Luigi Pirelli > > > ** > * LinkedIn:

Re: [Qgis-user] DB Manager cannot connect to PostGIS (error with traceback)

working on that... seems Boundless master repo remained to november Luigi Pirelli ** * LinkedIn: https://www.linkedin.com/in/luigipirelli * Stackexchange:

Re: [Qgis-user] DB Manager cannot connect to PostGIS (error with traceback)

Well, I don't know if they're inclined to do it but it would nice to know how they want to manage it... This is a severe bug for Windows. Giovanni Il lun 19 mar 2018, 13:34 Luigi Pirelli ha scritto: > he PR was from Boundless repo, make sense to ask to boundless if they >

Re: [Qgis-user] DB Manager cannot connect to PostGIS (error with traceback)

he PR was from Boundless repo, make sense to ask to boundless if they want to continue to support QGIS porting patches to 3.0? Luigi Pirelli ** * LinkedIn: https://www.linkedin.com/in/luigipirelli *

Re: [Qgis-user] DB Manager cannot connect to PostGIS (error with traceback)

yes sorry... not yet merged, and the PR have to be aligned to the current code Luigi Pirelli ** * LinkedIn: https://www.linkedin.com/in/luigipirelli * Stackexchange:

Re: [Qgis-user] DB Manager cannot connect to PostGIS (error with traceback)

Thanks Luigi, I already tried removing it manually, but it's created again every time. So, does this mean that DB Manager for PostGIS on QGIS 3/Windows is currently broken? Giovanni 2018-03-19 11:07 GMT+01:00 Luigi Pirelli : > you can safetly remove >

Re: [Qgis-user] DB Manager cannot connect to PostGIS (error with traceback)

you can safetly remove C:/Users/giohappy/AppData/Local/Temp/tmp_basic_{4703a7e8-5f5a-44ec-b490-7fd4ec0e9f7f}.pem and try again btw it was fixed since in month in 2-18 https://github.com/qgis/QGIS/pull/5477 but port to 3.0 was stopped https://github.com/qgis/QGIS/pull/5599 due Boundless closed the

[Qgis-user] DB Manager cannot connect to PostGIS (error with traceback)

Hi all, I'm facing the following issue with QGIS 3.1.0 (10044fb1dd ) on Windows 10. I can define a connection to my local PG, using basic authentication, and I can access data from Browser. If I try to open the connection from DB Manager I obtain;

[Qgis-user] DB Manager not showing Spatialite/Geopackage databases on Mac OS X.11

Hi, On my setup (QGIS 2.18 Mac OS X.11), the DB Manager doesn't show the Spatialite/Geopackages files that are listed in the browser. Besides that, Spatialite/Geopackages work as expected. The problem doesn't occur on my Windows system. Am I the only one experiencing this issue ? Any idea were

Re: [Qgis-user] DB manager error

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

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):

[Qgis-user] DB Manager SQL window does not open

Hi all, When I try to open the SQL window in DB Manager, I get this error : AttributeError: 'SqlEdit' object has no attribute 'setMarginVisible' I'm using Ubuntu 14.04. Here's the complete error message : AttributeError: 'SqlEdit' object has no attribute 'setMarginVisible' Traceback (most

[Qgis-user] DB Manager spatialite query NOT working

I am using qgis 2.14.1 on fedora 21 Linux I've done this successfully in older versions of qgis but it's not working now and I don't kjnow why. So I open a spatialite database in DB manager.  I can add tables with and without geometry

Re: [Qgis-user] DB Manager geometry problems

s-user@lists.osgeo.org Ämne: [Qgis-user] DB Manager geometry problems Hi I have several datasets loaded into PostGIS 2.0 with the owner as ‘superuser’ that has full permissions. I have then assigned select permissions to some other users, but I am not sure if they completely have the

Re: [Qgis-user] DB Manager geometry problems

s-user@lists.osgeo.org Ämne: [Qgis-user] DB Manager geometry problems Hi I have several datasets loaded into PostGIS 2.0 with the owner as ‘superuser’ that has full permissions. I have then assigned select permissions to some other users, but I am not sure if they completely have the access they r

[Qgis-user] DB Manager geometry problems

Hi I have several datasets loaded into PostGIS 2.0 with the owner as 'superuser' that has full permissions. I have then assigned select permissions to some other users, but I am not sure if they completely have the access they require as the DB Manager doesn't show the spatial reference, and

Re: [Qgis-user] DB Manager in QGIS 2.8

Hello David, Can I assume that you use fires.id as unique integer value column in DBManager to load the layer? Because with your query you will likely get repeated values for fires.id. That is, each fires feature will appear as many times as lakes within 1000 meters. If that's what you want,

Re: [Qgis-user] DB Manager in QGIS 2.8

Alexandre, Thank you very much. Of course, it was operator error! I was writing a quick query for a demo and not to solve a real problem, so I hadn't really thought through the issue with unique results. Adding DISTINCT made it work as expected. A great enhancement to DB Manager would be some

Re: [Qgis-user] DB Manager in QGIS 2.8

Can you please show your sql query? Notice that if your query result in different geometries, qgis won't be able to choose a geometry type for the layer. I advice you to Check your results with St_GeometryType(). Best regards, Alexandre Neto Em 18/03/2015 18:52, David Fawcett

Re: [Qgis-user] DB Manager in QGIS 2.8

Thanks for the response Alexandre. Here is the query: SELECT fires.id, fires.inci_no, fires.descript, fires.geom FROM lab.mpls_fires_2014 fires INNER JOIN lab.mpls_lakes lakes ON ST_DWITHIN(fires.geom, lakes.geom, 1000) When I add ST_GEOMETRYTYPE(fires.geom) to the query, the value is

[Qgis-user] DB Manager in QGIS 2.8

I am running QGIS 2.8.1 on OSX 10.9.5 using William's binaries. The DB Manager plugin is at 0.1.20. I can load layers into PostGIS using the DB Manager plugin, and I can use the SQL window to execute a spatial query intersecting two tables. But, when I check the box to load the query result as

[Qgis-user] DB Manager query no geometry column

Is there a way to do a query to add a table with no geometry? I am not able to do so -- View this message in context: http://osgeo-org.1560.x6.nabble.com/DB-Manager-query-no-geometry-column-tp5161344.html Sent from the Quantum GIS - User mailing list archive at Nabble.com.

[Qgis-user] DB Manager

Hi list, I've been struggling with DB Manager, and I hope someone can explain me what the problem is. I am querying a PostGIS table but when I try to load the SELECT results to map canvas nothing happens! A simple example: SELECT * FROM FREGUESIAS_2013 where freguesia ILIKE 'a%' returns thos

Re: [Qgis-user] DB Manager

Hi André, what QGIS and PostGIS versions are you running? Regards. On Sun, Feb 2, 2014 at 3:59 PM, ALT SHN i.geograf...@alt-shn.org wrote: Hi list, I've been struggling with DB Manager, and I hope someone can explain me what the problem is. I am querying a PostGIS table but when I try to

Re: [Qgis-user] DB Manager

André, I believe that DB manager (or actually the Postgis provider to QGIS) does not like some expressions, maybe the CASE WHEN is the problem... I remember having problems with the expression WITH foo as (...). The good news are: You alredy found the workaround. Alexandre Neto On Sun, Feb

Re: [Qgis-user] DB Manager

Hi Alexandre, On Sun, Feb 2, 2014 at 11:28 PM, Alexandre Neto senhor.n...@gmail.comwrote: I believe that DB manager (or actually the Postgis provider to QGIS) does not like some expressions, maybe the CASE WHEN is the problem... I remember having problems with the expression WITH foo as

[Qgis-user] DB manager don't load postgis tables (not geometric tables)

Hello As I understood db manager should load alphanumeric tables, right? In my installation of qgis (2.0.1) it doesn't.. When I try to drag and drop a table (not geometries, they work as expected), I get an error saying: Interrogazione errata: SELECT

Re: [Qgis-user] DB manager don't load postgis tables (not geometric tables)

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Il 12/11/2013 14:32, Pietro Rossin ha scritto: Hello As I understood db manager should load alphanumeric tables, right? In my installation of qgis (2.0.1) it doesn't.. Please have a look to the bugtracker: I have reported a similar issue

Re: [Qgis-user] db-manager (temporary tables)

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Il 22/10/2013 15:42, Jrgen E. Fischer ha scritto: QGIS and the db_manager use separate sessions. I didn't try, but I doubt that you can load temporary layers created by db_manager into qgis. you can, however, run a query and load its results as

[Qgis-user] db-manager (temporary tables)

Hi, Is there a way to access temporary tables through db-manager? From what I get, this is only possible through layer-add postgis layer (also not available in the browser panel). Thanks, António ___ Qgis-user mailing list Qgis-user@lists.osgeo.org

Re: [Qgis-user] db-manager (temporary tables)

Hi, You can load query results in db-manager. Just create a query in db-manager, select the primary key column and the geometry column and load it. Works fine for me. Andreas Am 22.10.2013 13:42, schrieb António M. Rodrigues: Hi, Is there a way to access temporary tables through

Re: [Qgis-user] db-manager (temporary tables)

The thing is I have some custom functions which output temp tables. And it would be useful to be able to explore these tables in db-manager. I guess it shouldn't be too difficult to tweak dbmanager. I was looking at the source code for but unfortunately my knowledge of pyqgis is not quite there

Re: [Qgis-user] db-manager (temporary tables)

What do you mean by temp tables? There are no temp tables in a database. Either it is a table, a view or a table. All of these can already be opened with DB manager. Andreas Am 22.10.2013 13:57, schrieb António M. Rodrigues: The thing is I have some custom functions which output temp tables.

Re: [Qgis-user] db-manager (temporary tables)

In postgres I can use 'create temporary table...' which will create a new object which only exists in the present session. It can only be stored in special schemas (which can be accessed from layer-- add postgis layer), called pg_tmp_'some integer'. I was just saying it would be nice to be able

Re: [Qgis-user] db-manager (temporary tables)

ok - wasn't aware of that. What is the advantage of using these temp tables? That you do not have to deal with deleting the table? I am not too familiar with the internals of db-manager. Does it establish a session? Probably Giuseppe Sucameli can help. Andreas Am 22.10.2013 14:10, schrieb

Re: [Qgis-user] db-manager (temporary tables)

For me the advantage is simple: I have a few plpgsql functions which create tables with variables computed from some quite large tables. I then use these tables as input to create other result tables (with geometry). And yes, the advantage is not to deal with multiple deleting in the end of each

Re: [Qgis-user] db-manager (temporary tables)

Hi António, On Tue, 22. Oct 2013 at 13:29:57 +0100, António M. Rodrigues wrote: As you say, perhaps the best is to contact Giuseppe Sucameli to see whether this could be improved (if of course is an useful feature for other users). QGIS and the db_manager use separate sessions. I didn't try,

Re: [Qgis-user] db-manager (temporary tables)

Hi Jürgen, Thanks for that. I did some testing following your e-mail. After creating a layer in db_manager, I tried to load it and got an error: dbname='testes'(...)key='r_table_catalog' table=pg_temp_7.nnn2 sql= is an invalid layer - not loaded I guess I'll have to think of

Re: [Qgis-user] db manager plugin problem loading features from esri personal geodb

Hi Paolo I'm using the dev version in windows 1.9.0 (1.9.0-Master Revisione codice QGIS d821bcc) But I'm getting this error.. bie 2013/8/7 Paolo Cavallini [via OSGeo.org] ml-node+s1560n5071296...@n6.nabble.com -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Il 07/08/2013 14:53, Pietro

Re: [Qgis-user] db manager plugin problem loading features from esri personal geodb

While using a shp file it runs to the end of loading. But I loose the Z dimension... Thanks Pietro 2013/8/8 Pietro Rossin pieri...@gmail.com Hi Paolo I'm using the dev version in windows 1.9.0 (1.9.0-Master Revisione codice QGIS d821bcc) But I'm getting this error.. bie 2013/8/7 Paolo

Re: [Qgis-user] db manager plugin problem loading features from esri personal geodb

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Il 08/08/2013 16:00, Pietro Rossin ha scritto: While using a shp file it runs to the end of loading. But I loose the Z dimension... ok, then it is probably a genuine bug. please open a ticket, with a minimalistic way of replicating it. thanks. - --

[Qgis-user] db manager plugin problem loading features from esri personal geodb

Hello community I'm using Qgis Master and db manager plugin updated today. In qgis I can load an esri personal geodb polyline layer correctly If I try to upload to a postgis schema with dbmanager I get an error after a while. I select to create a primary key, to call geom the geometry column, I

Re: [Qgis-user] db manager plugin problem loading features from esri personal geodb

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Il 07/08/2013 14:53, Pietro Rossin ha scritto: What can I do?? Hi Pietro, this is a known problem (MULTI geoms). It has been fixed on the dev version, please use it. All the best. - -- Paolo Cavallini - Faunalia www.faunalia.eu Full contact

[Qgis-user] DB Manager POINTZ error?

Using qgis 1.8 on Fedora 18. I have a spatialite db with pointz values in a table. I can display the table in qgis without problems. If I define a query I get results in the Result view but if I try to Load the query to qgis to

[Qgis-user] DB Manager - setting up a PostGIS connection, building SQL queries

Greetings, I've been using Q-GIS for under a year. My first system was built on Fedora 17, Postgresql 9.1.x, PostGIS 1.5.x, and Q-GIS Lisboa (1.8.x). It was on Dell Inspiron 600m, a machine that was reliable, but somewhat slow. I've acquired a Dell D630 Latitude laptop w/ a dual-core processor.

Re: [Qgis-user] DB Manager and Varchar field lengths

Il 21/09/2012 16:00, James Stott ha scritto: Does anyone know why DB Manager is reporting that my varchar fields are 4 characters longer than they actually are? When I create a table in DB manager (say as 6 length) it reports that it is 10. Then if I look at the table in PGAdmin it says

[Qgis-user] DB Manager errors loadin shapefile to PostGIS

I'm obtaining the following errors when I try to load (dragdrop) a shapefile do PostGIS. I'm running PostGIS 1.5 on Postgresql 9.1. QGis 1.9 on Windows 7 64bit. The first error (ERROR1) I've supposed was an encoding issue and float overflow due to the coordinate fields in the DBF. The DB

Re: [Qgis-user] DB Manager errors loadin shapefile to PostGIS

I've just tried to load the corrected version (ERROR2) with shp2pgsql and it works fine. giovanni 2012/8/23 G. Allegri gioha...@gmail.com I'm obtaining the following errors when I try to load (dragdrop) a shapefile do PostGIS. I'm running PostGIS 1.5 on Postgresql 9.1. QGis 1.9 on Windows

Re: [Qgis-user] DB Manager release

2011/9/15 Paolo Cavallini cavall...@faunalia.it: Hi all. Thanks to the hard work of Giuseppe Sucameli, the supervision of Martin Dobias, and the support of Google for its Summer of Code initiative, DB Manager is now available. DBManager's aim is to merge together some QGis DB plugins, e.g.

[Qgis-user] DB Manager release

Hi all. Thanks to the hard work of Giuseppe Sucameli, the supervision of Martin Dobias, and the support of Google for its Summer of Code initiative, DB Manager is now available. DBManager's aim is to merge together some QGis DB plugins, e.g. PGManager, SLManager, RT_Sql_Layer. In this moment it