columns: id (SERIAL) | size (INTEGER NULLABLE) | model (VARCHAR NULLABLE)
Connected into VDB using JDBC like:
generatedKeys is empty if:
- INSERT INTO "form_shoes_2" ( "model" ) VALUES ( 'adidas x1' ) ...... e.g. not all columns are enumerated ... if so, you can provide NULL values to optional columns and generated keys WORK!
- INSERT INTO "_view_workflow_data" (id, name, size) VALUES (42, 'adidas x2', 12 ) ....... e.g. insering into view (1:1, no joins involved) even when all columns ARE enumerated ... probably no way how to get generated keys here?
- How to get last_insert_id() when inserting into foreign table/views (with/without joins)?
- How to get updated rows (UPDATE ... RETURNING *)? At least primary keys of affected rows?
Thanks for fixing/adding this functionality.