[Qgis-user] Editing attributes in embedded forms

[Pekka Sarkola]

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