[Qgis-user] Editing attributes in embedded forms

[Pekka Sarkola]

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
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20210603/bde67c05/attachment.html>