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" <tiago@mdtestudio.com.br> 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