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

Re: [GENERAL] Delete Duplicates with Using

2017-10-15 Thread Igal @ Lucee.org
On 10/14/2017 12:32 AM, legrand legrand wrote: DELETE FROM table_with_duplicates AS T1 USING table_with_duplicates AS T2 WHERE T1.column_1 = T2.column_1 AND T1.column_2 = T2.column_2 AND T1.column_3 = T2.column_3 AND T1.row_num < T2.row_num Thank you, I

Re: [GENERAL] Non-overlapping updates blocking each other

2017-10-15 Thread Melvin Davidson
On Sun, Oct 15, 2017 at 8:01 AM, Seamus Abshere wrote: > > On Sat, Oct 14, 2017 at 10:30 AM, Seamus Abshere > > > UPDATE [...] WHERE id BETWEEN 'ff00----' > AND > > > 'ff0f----' > > > and > > >

Re: [GENERAL] Is pgbouncer still maintained?

2017-10-15 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 Steven Winfield wrote: > we are becoming increasingly worried by the lack of a new release > since February 2016 and a slowdown in development activity on the master > branch. > https://github.com/pgbouncer/pgbouncer ... A good point:

Re: [GENERAL] EAV Designs for Multi-Tenant Applications

2017-10-15 Thread Alban Hertroys
> On 12 Oct 2017, at 16:48, Nic Pottier wrote: … > We have thousands of organizations, some organizations have hundreds of > custom fields. Some organizations have millions of contacts. We have tens of > millions of values across organizations, so relatively sparse with

Re: [GENERAL] Non-overlapping updates blocking each other

2017-10-15 Thread Seamus Abshere
> On Sat, Oct 14, 2017 at 10:30 AM, Seamus Abshere > > UPDATE [...] WHERE id BETWEEN 'ff00----' AND > > 'ff0f----' > > and > > UPDATE [...] WHERE id BETWEEN 'f8c0----' AND > >