Re: [HACKERS] [COMMITTERS] pgsql: Release note updates.

2017-02-07 Thread Pavan Deolasee
On Tue, Feb 7, 2017 at 9:29 PM, Alvaro Herrera wrote: > Alvaro Herrera wrote: > > > > > Hmm. Now that I think about it, it is probably possible to have a > > transaction started before CIC that inserted a bunch of rows, and then > > runs the UPDATE during the CIC race window. Maybe there's a re

Re: [HACKERS] [COMMITTERS] pgsql: Release note updates.

2017-02-07 Thread Alvaro Herrera
Alvaro Herrera wrote: > Tom Lane wrote: > > Alvaro Herrera writes: > > > > May I suggest > > > > > + If CREATE INDEX CONCURRENTLY was used to build an index > > > + that depends on a column not previously indexed, then rows > > > + updated by transactions that ran concurrently wit

Re: [HACKERS] [COMMITTERS] pgsql: Release note updates.

2017-02-07 Thread Alvaro Herrera
Tom Lane wrote: > Alvaro Herrera writes: > > May I suggest > > > + If CREATE INDEX CONCURRENTLY was used to build an index > > + that depends on a column not previously indexed, then rows > > + updated by transactions that ran concurrently with > > + the CREATE INDEX command

Re: [HACKERS] [COMMITTERS] pgsql: Release note updates.

2017-02-07 Thread Tom Lane
Alvaro Herrera writes: > Tom Lane wrote: >> (I fear this is too late for the current set of releases; I don't want >> to make the packagers redo their work just for this. But we can correct >> it for future wraps.) > I think a large fraction of the readers will grab the release notes from > the

Re: [HACKERS] [COMMITTERS] pgsql: Release note updates.

2017-02-07 Thread Tom Lane
Alvaro Herrera writes: > Tom Lane wrote: >> Release note updates. > Sorry for not noticing earlier, but there is a bug in the notes: Mmm, right. > May I suggest > + If CREATE INDEX CONCURRENTLY was used to build an index > + that depends on a column not previously indexed, then rows

Re: [HACKERS] [COMMITTERS] pgsql: Release note updates.

2017-02-07 Thread Pavan Deolasee
On Tue, Feb 7, 2017 at 5:23 PM, Alvaro Herrera wrote: > Tom Lane wrote: > > Release note updates. > > > > Add item for last-minute CREATE INDEX CONCURRENTLY fix. > > Hi, > > Sorry for not noticing earlier, but there is a bug in the notes: > > + If CREATE INDEX CONCURRENTLY was used to build

Re: [HACKERS] [COMMITTERS] pgsql: Release note updates.

2017-02-07 Thread Alvaro Herrera
Tom Lane wrote: > Release note updates. > > Add item for last-minute CREATE INDEX CONCURRENTLY fix. Hi, Sorry for not noticing earlier, but there is a bug in the notes: + If CREATE INDEX CONCURRENTLY was used to build an index + that depends on a column not previously indexed, then ro