Skip site navigation (1) Skip section navigation (2)

Re: BUG #3479: contraint exclusion and locks

From: Tiago Daniel Jacobs <tiago(at)mdtestudio(dot)com(dot)br>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #3479: contraint exclusion and locks
Date: 2007-11-01 15:17:44
Message-ID: 4729EE18.4080907@mdtestudio.com.br (view raw or flat)
Thread:
Lists: pgsql-bugs
<!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]&nbsp; &nbsp;&nbsp; REINDEX TABLE month_a;<br>
[conn #2]&nbsp; &nbsp;&nbsp; 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">&lt;tiago(at)mdtestudio(dot)com(dot)br&gt;</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>


Attachment: unknown_filename
Description: text/html (1.0 KB)

In response to

pgsql-bugs by date

Next:From: MichaelDate: 2007-11-01 18:50:01
Subject: Re: PostgreSQL crash on Freebsd 7
Previous:From: Idris KhanafiDate: 2007-11-01 04:29:57
Subject: Tsearch in Postgresql 8.2.5

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group