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