In my table definition I have default values for auditing i.e logging the database user creating the record and time
date_created date NULL DEFAULT now(),
edited_by varchar NULL DEFAULT "current_user"(),
When a record is inserted via Geoserver WFS-T these default values are not triggered. I am curious to why and if I can do something about it?
Both these basic examples triggers the default values to inject expected default values
INSERT INTO test_table
(notes, dato, edited_by)
VALUES('test', now(), "current_user"());
INSERT INTO test_table
(notes)
VALUES('test2');
Make me belive Geoserver actually produces this SQL?
INSERT INTO test_table
(notes, dato, edited_by)
VALUES('test', null, null);