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_check

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 current HEAD is

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

2012-02-27 Thread Pavel Stehule
2012/2/27 Alvaro Herrera alvhe...@commandprompt.com: 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 -

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 alvhe...@commandprompt.com: 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 alvhe...@commandprompt.com: Excerpts from Pavel Stehule's message of lun feb 27 10:41:32 -0300 2012: 2012/2/27 Alvaro Herrera alvhe...@commandprompt.com: Excerpts from hubert depesz lubaczewski's message of lun feb 27 10:02:57 -0300 2012: On Sun, Feb 26, 2012