[GENERAL] sequence used on null value or get the max value for a column whithconcurrency

Поиск
Список
Период
Сортировка
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?

Alternatively:

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

TIA





В списке pgsql-general по дате отправления:

Предыдущее
От: armand pirvu
Дата:
Сообщение: Re: [GENERAL] pglogical sync
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: [GENERAL] sequence used on null value or get the max value for acolumn whith concurrency