[Qgis-user] Editing attributes in embedded forms

[Alexandre Neto]

>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/20210601/b89bfcd9/attachment.html>