This PR https://github.com/qgis/QGIS/pull/43529 should fix the issue.
On Thu, Jun 3, 2021 at 10:40 AM Alessandro Pasotti <[email protected]> wrote: > Yeah, good catch. > > I'm working on it now, a patch is on the way. > > Cheers > > > On Thu, Jun 3, 2021 at 10:30 AM Bo Victor Thomsen < > [email protected]> wrote: > >> There is something odd about how QGIS fetches values from the sequence: >> >> The error message states that : >> >> *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)* >> >> ^ >> >> However - a correct call to the "nextval" function should loke like this: >> >> *SELECT nextval('sample_point_fid_seq'::regclass)* >> >> *Not* like this ( " contra ') : >> >> *SELECT nextval("sample_point_fid_seq"::regclass)* >> >> So the call fails twice : It calls a non-existing sequence and the >> function argument should be 'sample_point_fid_seq'::regclass , not >> "sample_point_fid_seq"::regclass >> >> Med venlig hilsen / Kind regards >> >> Bo Victor Thomsen >> >> Den 03-06-2021 kl. 08:23 skrev Pekka Sarkola: >> >> 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 >> [email protected] - GSM +358 40 725 2042 >> www.gispo.fi – www.paikkatieto.com >> >> >> to 3. kesäk. 2021 klo 8.47 Pekka Sarkola ([email protected]) 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 >>> [email protected] - GSM +358 40 725 2042 >>> www.gispo.fi – www.paikkatieto.com >>> >>> >>> ti 1. kesäk. 2021 klo 16.36 Alexandre Neto ([email protected]) >>> 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 <[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 [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 >> > > > -- > Alessandro Pasotti > QCooperative: www.qcooperative.net > ItOpen: www.itopen.it > -- Alessandro Pasotti QCooperative: www.qcooperative.net ItOpen: www.itopen.it
_______________________________________________ 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
