Re: [Qgis-user] Unable to save project to PostgreSQL

2020-05-29 Thread Cliff Patterson
UPDATE: I found the problem. We were using an older docker image that was running PostGIS 2.1.4 (or something like that). I upgraded PostgreSQL to 11.5 and PostGIS to 2.5. At the time of posting this to the user group, I had not even looked at how the stack was set up and assumed it was the most re

Re: [Qgis-user] Unable to save project to PostgreSQL

2020-05-28 Thread Jorge Gustavo Rocha
Hi Cliff, Thank you for including the failing database insert/update. I think you found a bug. When QGIS writes the project to the provider, it encodes the project as a huge hexadecimal string. But your project's hex string is not valid. I don't know why, but it should not be invalid. Please cre

[Qgis-user] Unable to save project to PostgreSQL

2020-05-28 Thread Cliff Patterson
Hi QGISers! I am unable to save a project to PostgreSQL in QGIS version 3.10.4-A Coruña. "Allow saving/loading projects..." is enabled for this DB. The user is the db owner and I can insert into the table using PGAdmin with the same creds. However, when I try to save a project to the DB in QGIS, I