In some table, I have a bigint column which at the app level can be null. Call it "DocumentNumber", and of course is not the PK.
In most cases, the applications give some value to the column.

But sometimes, the value remains null, expecting the backend or someone assign it a unique value.

Could I use a sequence only when the field arrives to the backend as null? How? Using a triger?


How could I get the max value for the column and increment it by one, but with concurrency warranty? Something as a table lock?


Sent via pgsql-general mailing list (
To make changes to your subscription:

Reply via email to