Re: [HACKERS] check constraint validation takes access exclusive locks

2012-02-27 Thread Pavel Stehule
2012/2/27 Alvaro Herrera : > > Excerpts from Pavel Stehule's message of lun feb 27 10:41:32 -0300 2012: >> >> 2012/2/27 Alvaro Herrera : >> > >> > Excerpts from hubert depesz lubaczewski's message of lun feb 27 10:02:57 >> > -0300 2012: >> >> On Sun, Feb 26, 2012 at 03:04:28PM +0100, Pavel Stehule

Re: [HACKERS] check constraint validation takes access exclusive locks

2012-02-27 Thread Alvaro Herrera
Excerpts from Pavel Stehule's message of lun feb 27 10:41:32 -0300 2012: > > 2012/2/27 Alvaro Herrera : > > > > Excerpts from hubert depesz lubaczewski's message of lun feb 27 10:02:57 > > -0300 2012: > >> On Sun, Feb 26, 2012 at 03:04:28PM +0100, Pavel Stehule wrote: > >> > Hello > >> > > >> >

Re: [HACKERS] check constraint validation takes access exclusive locks

2012-02-27 Thread Pavel Stehule
2012/2/27 Alvaro Herrera : > > Excerpts from hubert depesz lubaczewski's message of lun feb 27 10:02:57 > -0300 2012: >> On Sun, Feb 26, 2012 at 03:04:28PM +0100, Pavel Stehule wrote: >> > Hello >> > >> > I rechecked Depesz's article - >> > http://www.depesz.com/2011/07/01/waiting-for-9-2-not-vali

Re: [HACKERS] check constraint validation takes access exclusive locks

2012-02-27 Thread Alvaro Herrera
Excerpts from hubert depesz lubaczewski's message of lun feb 27 10:02:57 -0300 2012: > On Sun, Feb 26, 2012 at 03:04:28PM +0100, Pavel Stehule wrote: > > Hello > > > > I rechecked Depesz's article - > > http://www.depesz.com/2011/07/01/waiting-for-9-2-not-valid-checks/ > > > > The behave of cur

Re: [HACKERS] check constraint validation takes access exclusive locks

2012-02-27 Thread hubert depesz lubaczewski
On Sun, Feb 26, 2012 at 03:04:28PM +0100, Pavel Stehule wrote: > Hello > > I rechecked Depesz's article - > http://www.depesz.com/2011/07/01/waiting-for-9-2-not-valid-checks/ > > The behave of current HEAD is different than behave described in article. > > "alter table a validate constraint a_a_

[HACKERS] check constraint validation takes access exclusive locks

2012-02-26 Thread Pavel Stehule
Hello I rechecked Depesz's article - http://www.depesz.com/2011/07/01/waiting-for-9-2-not-valid-checks/ The behave of current HEAD is different than behave described in article. "alter table a validate constraint a_a_check" needs a access exclusive locks and blocks table modification - I tested