Adding identity column to a non-empty table

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/>