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

2017-10-15 Thread Igal @ Lucee.org
On 10/15/2017 6:42 PM, Melvin Davidson wrote: On Sun, Oct 15, 2017 at 9:09 PM, Igal @ Lucee.org > wrote: Melvin, On 10/15/2017 5:56 PM, Melvin Davidson wrote: On 10/15/2017 4:01 PM, Igal @ Lucee.org wrote: Hello,

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

2017-10-15 Thread Melvin Davidson
On Sun, Oct 15, 2017 at 9:09 PM, Igal @ Lucee.org wrote: > Melvin, > > On 10/15/2017 5:56 PM, Melvin Davidson wrote: > > > On Sun, Oct 15, 2017 at 8:24 PM, Igal @ Lucee.org wrote: > >> On 10/15/2017 4:01 PM, Igal @ Lucee.org wrote: >> >>> >>> Hello, >>> >>> I'm

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

2017-10-15 Thread Igal @ Lucee.org
Melvin, On 10/15/2017 5:56 PM, Melvin Davidson wrote: On Sun, Oct 15, 2017 at 8:24 PM, Igal @ Lucee.org > wrote: On 10/15/2017 4:01 PM, Igal @ Lucee.org wrote: Hello, I'm trying to add an identity column to a table that has

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

2017-10-15 Thread Melvin Davidson
On Sun, Oct 15, 2017 at 8:24 PM, Igal @ Lucee.org wrote: > On 10/15/2017 4:01 PM, Igal @ Lucee.org wrote: > >> >> 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 >>

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

2017-10-15 Thread Igal @ Lucee.org
On 10/15/2017 4:01 PM, Igal @ Lucee.org wrote: 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

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

2017-10-15 Thread 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