[GENERAL] Adding identity column to a non-empty table

[Igal @ Lucee.org]

Hello,

I'm trying to add an identity column to a table that has records 
(previously had a bigserial column which I removed):

  ALTER TABLE event_log
ADD COLUMN r_id BIGINT GENERATED BY DEFAULT AS IDENTITY;

But I'm getting an error `column r_id contains null values`.

How can I add the column and populate it for the existing rows?

Thanks,

Igal Sapir
Lucee Core Developer
Lucee.org <http://lucee.org/>