Upon inserting it would be nice to have a default value based on other columns in that same row.
Why can't you write that using the current DEFAULT implementation?
reopen for skinkie, as it seems he doesn't want to clarify otherwise
Other database support 'dynamic' DEFAULTs. Hence you are allowed to place an expression into the default. This is currently not possible in MonetDB where it is static.
I don't see the big problem (performance) problem in this as long the default is added on the end of a bulk transaction. Instead of foreach record. S in general it would be an 'on-insert-update-trigger', opposed to the other request 'on-update-update-trigger'.
as far as I know "DEFAULT NEXT VALUE FOR seq_X" is pretty dynamic
This bug was previously known as tracker item 2682714 at http://sourceforge.net/support/tracker.php?aid=2682714