Database default values don't work in QGIS

[ponceta]

Describe the bug
Database default values only work database side but are overwritten by QGIS

To Reproduce
Exact steps to reproduce the behavior:

1. Open TWW QGIS project
2. Define values for fk_provider and fk_dataowner
3. Create a Wastewater structure
4. default fk_provider and fk_dataowner are not displayed
5. Click ok and reopen the same form
6. fk_provider and fk_dataowner are not selected

Expected behavior
A user can define default fk_provider and fk_dataowner in QGIS too.

Screenshots / data

Desktop (please complete the following information):

• TWW version
• QGIS Version
• OS

Additional context
Add any other context about the problem here.

[cymed]

When did you create your default values entries? We only set the default values on od (using tww_app.set_default_values) by using a trigger on tww_od.default_values.

wastewater/datamodel/app/functions/organisation_functions.sql

Line 57 in c7c7e36

CREATE OR REPLACE FUNCTION tww_app.ft_set_default_values()

[sjib]

see also #425

[ponceta]

Default values have been inserted :

But when the db queries it, it returns NULL :

Is it right to call it BEFORE the INSERT?

wastewater/datamodel/app/functions/organisation_functions.sql

Lines 124 to 130 in 4a9d9bb

	DROP TRIGGER IF EXISTS set_default_values ON tww_od.default_values;
	CREATE TRIGGER set_default_values
	BEFORE INSERT OR UPDATE
	ON tww_od.default_values
	FOR EACH ROW
	EXECUTE PROCEDURE tww_app.ft_set_default_values();

My current workaround is to define QGIS variables :

But this will require some project configurations and I would rather have a db working solution.