[Qgis-user] Editing attributes in embedded forms

Alessandro Pasotti apasotti at gmail.com
Thu Jun 3 01:59:19 PDT 2021 

This PR https://github.com/qgis/QGIS/pull/43529 should fix the issue.


On Thu, Jun 3, 2021 at 10:40 AM Alessandro Pasotti <apasotti at gmail.com>
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 <
> bo.victor.thomsen at gmail.com> 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
>> pekka.sarkola at gispo.fi   - GSM +358 40 725 2042
>> www.gispo.fi – www.paikkatieto.com
>>
>>
>> to 3. kesäk. 2021 klo 8.47 Pekka Sarkola (pekka at 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.sarkola at gispo.fi   - GSM +358 40 725 2042
>>> www.gispo.fi – www.paikkatieto.com
>>>
>>>
>>> ti 1. kesäk. 2021 klo 16.36 Alexandre Neto (senhor.neto at 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 <pekka at 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.sarkola at gispo.fi   - GSM +358 40 725 2042
>>>>> www.gispo.fi – www.paikkatieto.com
>>>>>
>>>>>
>>>>> ti 1. kesäk. 2021 klo 11.10 Andreas Neumann (a.neumann at 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.sarkola at gispo.fi   - GSM +358 40 725 2042
>>>>>> www.gispo.fi – www.paikkatieto.com
>>>>>>
>>>>>> _______________________________________________
>>>>>> Qgis-user mailing list
>>>>>> Qgis-user at 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 at 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 listQgis-user at 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 at lists.osgeo.org
>> 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20210603/6844f42d/attachment.html>

More information about the Qgis-user mailing list