I’m having trouble getting an UPDATE to work correctly.
We have a table where some columns should be updated from a service call - and some columns should not (as they are updated elsewhere).
Setting the fields to readonly means that they can’t be edited - but are still put in the autogenerated UPDATE statement - and so that overwrites the values updated on our server (if they were updated between when the data was read and when the data is saved.)
I’d hoped I could get around this by creating my own UpdateCommand and using the UpdateCommandName to use this new command - but this seems to be being ignored and is still using the autogenerated UPDATE statement (I can see this in the postgresql logs).
Any ideas/clues/gotchas I should be aware of ?