QGIS » QGIS Application

Thank you for the fast reply!

Have tried using full path.
I am not certain what you mean by 'dump of your table'. please specify.
The 'footprint2017' table is several GB when stored locally as a shapefile, can't really upload the whole thing. The 'temp' file is just empty.

And just for added information. We are 6 people using QGIS in the office and all six of us have this issue when trying to save more than ~10.000 features from our various databases.

Mark Falkenberg wrote:

Thank you for the fast reply!

Have tried using full path.
I am not certain what you mean by 'dump of your table'. please specify.
The 'footprint2017' table is several GB when stored locally as a shapefile, can't really upload the whole thing. The 'temp' file is just empty.

I mean a backup of the table create with the "pg_dump" tool, so we can restore it here locally and try to replicate the issue. Likely you will have to use an external service to link it here, as there is a 5mb limit for attachments.

And just for added information. We are 6 people using QGIS in the office and all six of us have this issue when trying to save more than ~10.000 features from our various databases.

understand, but I also said that here there are no issues in saving multiple gb vectors (to shape, geopackage, etc.) on different platforms (linux, windows) using postgis data as sources.

Before i start with the pg_dump I just noticed this;

When attempting to save i get the following
Log message panel message for PostGIS panel:
------------------------------------------------------------------------------------------------------------------------------------------------------
2017-12-01T12:51:46 1 NOTICE: WARNING: there is no transaction in progress
2017-12-01T12:58:19 1 invalid PostgreSQL layer
2017-12-01T13:00:14 1 Query: DECLARE qgis_5 BINARY CURSOR FOR SELECT st_asbinary("geom",'NDR'),"imageid"::text FROM "public"."fp_cap_test2" WHERE ("imageid"::text='2017_81_10_2_0029_00000449'
OR "imageid"::text='2017_81_10_4_0006_00001696'
OR "imageid"::text='2017_81_10_4_0007_00001870'
OR "imageid"::text='2017_81_09_1_0021_00000674'... so on and so on...
...
...
...
OR "imageid"::text='2017_81_09_1_0021_00000680')
Result: 7 (ERROR: stack depth limit exceeded
HINT: Increase the configuration parameter "max_stack_depth" (currently 2048kB), after ensuring the platform's stack depth limit is adequate.)

2017-12-01T13:00:19 1 Query: CLOSE qgis_6 returned 7 [ERROR: cursor "qgis_6" does not exist]
2017-12-01T13:00:19 1 NOTICE: NOTICE: there is no transaction in progress
------------------------------------------------------------------------------------------------------------------------------------------------------

Any info on how I increase the 'max_stack_depth'? Googling I only found a entry in french :)

Hi,
See https://www.postgresql.org/docs/9.4/static/runtime-config-resource.html

I think you have issues with your postgresql.conf. Maybe you can share it (though this is not a QGIS specific issue)?