Hi, You repeat this "ERROR: column "sample_point_fid_seq" does not exist" -problem with:
Create very simple table to PostGIS (choose your own CRS): CREATE TABLE IF NOT EXISTS sample_point ( fid integer NOT NULL GENERATED ALWAYS AS IDENTITY, wkb_point geometry(Point,3067), name varchar, CONSTRAINT sample_point_pk PRIMARY KEY (fid) ); Add table to QGIS. Editing works, without errors. If you tick on from project properties: "Evaluate default values on provider side", error will happen: 2021-06-03T09:22:31 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) ^ ] Rgs, Pekka Pekka Sarkola Gispo Oy pekka.sark...@gispo.fi - GSM +358 40 725 2042 www.gispo.fi – www.paikkatieto.com to 3. kesäk. 2021 klo 8.47 Pekka Sarkola (pe...@gispo.fi) kirjoitti: > 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