Hi Alexandre et al, I re-create a database (sample one), create a new QGIS project, add layers => same error. Maybe I open an issue in Github and I can share more SQL and snapshots.
Rgs, Pekka Pekka Sarkola Gispo Oy pekka.sark...@gispo.fi - GSM +358 40 725 2042 www.gispo.fi – www.paikkatieto.com ti 1. kesäk. 2021 klo 16.36 Alexandre Neto (senhor.n...@gmail.com) kirjoitti: > 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 <pe...@gispo.fi> 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 >> pekka.sark...@gispo.fi - GSM +358 40 725 2042 >> www.gispo.fi – www.paikkatieto.com >> >> >> ti 1. kesäk. 2021 klo 11.10 Andreas Neumann (a.neum...@carto.net) >> 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 >>> pekka.sark...@gispo.fi - GSM +358 40 725 2042 >>> www.gispo.fi – www.paikkatieto.com >>> >>> _______________________________________________ >>> Qgis-user mailing list >>> Qgis-user@lists.osgeo.org >>> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user >>> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user >>> >>> >>> _______________________________________________ >> Qgis-user mailing list >> Qgis-user@lists.osgeo.org >> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user >> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user >> >
_______________________________________________ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user