Re: [BUGS] BUG #3479: contraint exclusion and locks

[Tiago Daniel Jacobs]

Hi, why if I REINDEX a inherited table, all tables are locked? Example: [conn #1]     REINDEX TABLE month_a; [conn #2]     PREPARE updt as update month_b set col_a=1 where col_b=$1; The query on conn#2 waits. regards, Tiago Tom Lane escreveu: "Tiago Jacobs" <[EMAIL PROTECTED]> writes: oh-ow... It waits while the table (That is not used) is locked. This is not a bug. It has to inspect the table to find out that there is a constraint. regards, tom lane