<div dir="ltr">Hi Andreas,<div><br></div><div>Trasnsactions groups are enabled: editing is working (not in embedded forms) as expected.</div><div><br></div><div>If I enable "Evaluate default values.."-option, I will get error:</div><div><br></div><div>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<br> LINE 1: SELECT nextval("sample_point_fid_seq"::regclass)<br></div><div><br></div><div>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 ). </div><div><br></div><div>I presume this evaluation of the default values is not the solution for this case.</div><div><br></div><div>Rgs,</div><div><br></div><div>Pekka</div><div><div><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div dir="ltr"><div dir="ltr"><p><span style="font-size:12.8000001907349px">Pekka Sarkola<br></span><span style="font-size:12.8000001907349px">Gispo Oy<br></span><a href="mailto:pekka.sarkola@gispo.fi" style="font-size:12.8000001907349px" target="_blank">pekka.sarkola@gispo.fi</a><span style="font-size:12.8000001907349px"> -
GSM +358 40 725 2042<br></span><a href="http://www.gispo.fi/" style="font-size:12.8000001907349px" target="_blank">www.gispo.fi</a><span style="font-size:12.8000001907349px"> – </span><a href="http://www.paikkatieto.com/" style="font-size:12.8000001907349px" target="_blank">www.paikkatieto.com</a></p></div></div></div></div></div></div></div><br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">ti 1. kesäk. 2021 klo 11.10 Andreas Neumann (<a href="mailto:a.neumann@carto.net">a.neumann@carto.net</a>) kirjoitti:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div style="font-size:10pt;font-family:Verdana,Geneva,sans-serif">
<p>Hi Pekka,</p>
<p>Have you enabled the transaction mode in your project?</p>
<p>See menu "Project" --> "Properties" --> "Data Sources".</p>
<p>I usually enable all three check boxes:</p>
<p>- Automatically create transaction groups where possible</p>
<p>- Evaluate default values on provider side</p>
<p>- Trust project when data source has no metadata</p>
<p>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.</p>
<p>Greetings,</p>
<p>Andreas</p>
<p id="gmail-m_-7168818297288270819reply-intro">On 2021-06-01 09:55, Pekka Sarkola wrote:</p>
<blockquote type="cite" style="padding:0px 0.4em;border-left:2px solid rgb(16,16,255);margin:0px">
<div id="gmail-m_-7168818297288270819replybody1">
<div>
<div dir="ltr">Hi folks!
<div> </div>
<div>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. </div>
<div> </div>
<div>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.</div>
<div> </div>
<div>Any suggestions? Or should I write a better description to the Github?</div>
<div> </div>
<div>Rgs,</div>
<div> </div>
<div>Pekka</div>
<div>
<div>
<div dir="ltr">
<div dir="ltr">
<div>
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<p><span style="font-size:12.8px">Pekka Sarkola<br></span><span style="font-size:12.8px">Gispo Oy<br></span><a style="font-size:12.8px" href="mailto:pekka.sarkola@gispo.fi" rel="noreferrer" target="_blank">pekka.sarkola@gispo.fi</a><span style="font-size:12.8px"> - GSM +358 40 725 2042<br></span><a style="font-size:12.8px" href="http://www.gispo.fi/" rel="noopener noreferrer" target="_blank">www.gispo.fi</a><span style="font-size:12.8px"> – </span><a style="font-size:12.8px" href="http://www.paikkatieto.com/" rel="noopener noreferrer" target="_blank">www.paikkatieto.com</a></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<br>
<div style="margin:0px;padding:0px;font-family:monospace">_______________________________________________<br>Qgis-user mailing list<br><a href="mailto:Qgis-user@lists.osgeo.org" target="_blank">Qgis-user@lists.osgeo.org</a><br>List info: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noopener noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>Unsubscribe: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noopener noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a></div>
</blockquote>
<p><br></p>
</div>
</blockquote></div>