<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Hi, why if I REINDEX a inherited table, all tables are locked?<br>
<br>
Example:<br>
[conn #1] REINDEX TABLE month_a;<br>
[conn #2] PREPARE updt as update month_b set col_a=1 where col_b=$1;<br>
<br>
The query on conn#2 waits.<br>
<br>
regards,<br>
Tiago<br>
<br>
Tom Lane escreveu:
<blockquote cite="mid:24459(dot)1185201433(at)sss(dot)pgh(dot)pa(dot)us" type="cite">
<pre wrap="">"Tiago Jacobs" <a class="moz-txt-link-rfc2396E" href="mailto:tiago(at)mdtestudio(dot)com(dot)br"><tiago(at)mdtestudio(dot)com(dot)br></a> writes:
</pre>
<blockquote type="cite">
<pre wrap="">oh-ow... It waits while the table (That is not used) is locked.
</pre>
</blockquote>
<pre wrap=""><!---->
This is not a bug. It has to inspect the table to find out that
there is a constraint.
regards, tom lane
</pre>
</blockquote>
<br>
</body>
</html>