QfieldCloud: PostGIS offline editing- no errors, but no changes made to postgis

Hi- I’m trying to setup offline editing of my postgis layers and have reverted to the most simple of projects to try and get it working: An editable point layer.

The process appears to be working ok:

  1. Files are packaged to a local geopackage
  2. Uploaded to QFieldCloud
  3. The secret is added for a pg_service connection for which the user has all edit privilege’s.
  4. In the QField app, I download the project and open it, start editing, add and save a point.
  5. Then I sync the project back up to Qfield cloud.
  6. Examining the Jobs on Qfield Cloud, I see the Delta Apply job- all green ticks though there are a couple of warnings:
  • version mismatch of QGIS (3.26.2 vs 3.26.1)…but can’t imagine that will be an issue?
  • an warning about pk value..my source postgis layer has one other point, I just manually added a pk value of 999.

However, no edits have been applied to the database.

What am I missing here? Is there any other way I can debug this process ?
I see other discussions around adding the QGIS cloud IP address to the allowed connections- I think I have done this, but also, I don’t get any errors about refused connections either.
(note I’ve tried other projects and process with more complex layers and attribute forms but have setup this most basic project to try and get something working.


Imported from GitHub discussion by @timbo-barnes on 2022-10-27T20:32:15Z