>From that last error... Are you sure your table was not changed after being loaded to QGIS? It seems to expect a sequence that no longer exists.
Alexandre Neto A terça, 1/06/2021, 12:22, Pekka Sarkola <[email protected]> escreveu: > Hi Andreas, > > Trasnsactions groups are enabled: editing is working (not in embedded > forms) as expected. > > If I enable "Evaluate default values.."-option, I will get error: > > 2021-06-01T14:11:44 WARNING Erroneous query: SELECT > nextval("sample_point_fid_seq"::regclass) returned 7 [ERROR: column > "sample_point_fid_seq" does not exist > LINE 1: SELECT nextval("sample_point_fid_seq"::regclass) > > Primary key of the geometry table is "fid" and it has been defined as > IDENTITY column (fid integer NOT NULL GENERATED ALWAYS AS IDENTITY ( > INCREMENT 1 START 1 MINVALUE 1 MAXVALUE 2147483647 CACHE 1 ). > > I presume this evaluation of the default values is not the solution for > this case. > > Rgs, > > Pekka > > Pekka Sarkola > Gispo Oy > [email protected] - GSM +358 40 725 2042 > www.gispo.fi – www.paikkatieto.com > > > ti 1. kesäk. 2021 klo 11.10 Andreas Neumann ([email protected]) > kirjoitti: > >> Hi Pekka, >> >> Have you enabled the transaction mode in your project? >> >> See menu "Project" --> "Properties" --> "Data Sources". >> >> I usually enable all three check boxes: >> >> - Automatically create transaction groups where possible >> >> - Evaluate default values on provider side >> >> - Trust project when data source has no metadata >> >> The transaction mode allows to edit all layers from the same data base >> connection (needs identical db connection string and credentials) and - >> together with "evaluate default values on provider side" - immediately >> retrieves primary keys from the DB, so that you can link objects >> immediately, without having to save first. >> >> Greetings, >> >> Andreas >> >> On 2021-06-01 09:55, Pekka Sarkola wrote: >> >> Hi folks! >> >> I have a problem editing feature attributes in embedded forms. Data is >> stored in PostGIS and I have a simple 1:1 relationship with the geometry >> table and an additional attribute table. QGIS version is 3.18.3 on Ubuntu. >> >> I have created a custom form with a drag-and-drop designer. I can edit >> additional attribute table attributes in embedded form, but those edits are >> not stored anywhere. I have to open a separate form and then edit attribute >> values of the related attribute table. This is quite annoying for the end >> user. >> >> Any suggestions? Or should I write a better description to the Github? >> >> Rgs, >> >> Pekka >> >> Pekka Sarkola >> Gispo Oy >> [email protected] - GSM +358 40 725 2042 >> www.gispo.fi – www.paikkatieto.com >> >> _______________________________________________ >> Qgis-user mailing list >> [email protected] >> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user >> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user >> >> >> _______________________________________________ > Qgis-user mailing list > [email protected] > List info: https://lists.osgeo.org/mailman/listinfo/qgis-user > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user >
_______________________________________________ Qgis-user mailing list [email protected] List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
