Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 6A121650292
	for <pgsql-admin-postgresql.org@postgresql.org>;
	Thu, 17 Jul 2008 17:30:50 -0300 (ADT)
Received: from postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 52036-04 for <pgsql-admin-postgresql.org@postgresql.org>;
	Thu, 17 Jul 2008 17:30:43 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from wx-out-0506.google.com (wx-out-0506.google.com [66.249.82.237])
	by postgresql.org (Postfix) with ESMTP id 69DF86504AE
	for <pgsql-admin@postgresql.org>; Thu, 17 Jul 2008 17:30:46 -0300 (ADT)
Received: by wx-out-0506.google.com with SMTP id i31so50067wxd.28
	for <pgsql-admin@postgresql.org>; Thu, 17 Jul 2008 13:30:45 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:received:received:message-id:date:from:to
	:subject:mime-version:content-type;
	bh=I4zFwzbsLvjv42NcQTvX7cMrxk9MVE6gNzW27KCUNo0=;
	b=ZiNWm2PfUQDVXY7geUXD1fU4pbnbczTBzZRZ+9PW1iDKGBLWK3OQdpxzji0HTIOEOV
	1pb9LB7bHp2JMCFpTWOdtlmD429wC8F6U4qcpUnYly5i+U1tt6xlaP/BztKDn9zBoI4G
	0yydRBJBeGA74X9itYCskQfzxYzSBNx//Lm9U=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:to:subject:mime-version:content-type;
	b=b/uULtdAJeuSrOJyo0OJ9isfriav0cU/vbF/0Q66YU99WTX6JUylhGYRl0C2hYrmMo
	vE4Okn9B+THmQH3pyA0t4JQhTUTdXBgx9nNhLWbq50a0s6JRJ0DZaH1JjGbta9k88UTy
	nk6KlTomdKcCljraagO+yvt9B2o3JVc0ia1QA=
Received: by 10.114.79.18 with SMTP id c18mr2148415wab.86.1216326644573;
	Thu, 17 Jul 2008 13:30:44 -0700 (PDT)
Received: by 10.115.106.6 with HTTP; Thu, 17 Jul 2008 13:30:44 -0700 (PDT)
Message-ID: <f0c828c40807171330g140f08e1h73bc1add269d57b4@mail.gmail.com>
Date: Thu, 17 Jul 2008 16:30:44 -0400
From: "samantha mahindrakar" <sam.mahindrakar@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Multiple locks problem
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_47449_15288898.1216326644507"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.001 tagged_above=0 required=5
	tests=HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200807/156
X-Sequence-Number: 29766

------=_Part_47449_15288898.1216326644507
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi....
Below is the locks that are generated by my program. Can someone thrown some
light as to why i see multiple locks on the same table?.
I first insert data in the table 'imputed_prediction' and the select data
from it..........since i see locks on indexes.........................iam
assuming its happening during the selection of data.
I havent specifically defined locks either. However i select data from the
tabel across multiple functions.I see 4 locks on the same table
imputed_prediction......i insert data,select and truncate the table finally.
Under what conditions do we see such locks???The program runs too with this
condition.

"imputed_data_helper";85150013;2880;t;"AccessShareLock"
"imputed_data_helper_i1";85150013;2880;t;"AccessShareLock"
"imputed_data_helper_i2";85150013;2880;t;"AccessShareLock"
"imputed_data_helper_i3";85150013;2880;t;"AccessShareLock"
"imputed_data_helper_i4";85150013;2880;t;"AccessShareLock"
"imputed_data_helper_pk";85150013;2880;t;"AccessShareLock"
"imputed_lane_data_07_08";85150013;2880;t;"RowExclusiveLock"
"imputed_lane_data_07_08_measurement_start_i";85150013;2880;t;"RowExclusiveLock"
"imputed_lane_data_07_08_pk";85150013;2880;t;"RowExclusiveLock"
"imputed_lane_data_07_08_quality_i";85150013;2880;t;"RowExclusiveLock"
"imputed_prediction";85162809;1900;f;"ShareUpdateExclusiveLock"
"imputed_prediction";85150013;2880;t;"AccessShareLock"
"imputed_prediction";85150013;2880;t;"RowExclusiveLock"
"imputed_prediction";85150013;2880;t;"ShareLock"
"imputed_prediction";85150013;2880;t;"AccessExclusiveLock"
"imputed_prediction_i1";85150013;2880;t;"AccessExclusiveLock"
"imputed_prediction_i1";85150013;2880;t;"AccessShareLock"
"imputed_prediction_i2";85150013;2880;t;"AccessExclusiveLock"
"imputed_prediction_i2";85150013;2880;t;"AccessShareLock"
"imputed_prediction_i3";85150013;2880;t;"AccessShareLock"
"imputed_prediction_i3";85150013;2880;t;"AccessExclusiveLock"
"imputed_prediction_i4";85150013;2880;t;"AccessExclusiveLock"
"imputed_prediction_i4";85150013;2880;t;"AccessShareLock"
"imputed_prediction_i5";85150013;2880;t;"AccessExclusiveLock"
"imputed_prediction_i5";85150013;2880;t;"AccessShareLock"


Sam

------=_Part_47449_15288898.1216326644507
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

<div>Hi....</div>
<div>Below is the locks that are generated by my program. Can someone thrown some light as to why i see multiple locks on the same table?.</div>
<div>I first insert data in the table &#39;imputed_prediction&#39; and the select data from it..........since i see locks on indexes.........................iam assuming its happening during the selection of data.</div>
<div>I havent specifically defined locks either. However i select data from the tabel across multiple functions.I see 4 locks on the same table imputed_prediction......i insert data,select and truncate the table finally.</div>

<div>Under what conditions do we see such locks???The program runs too with this condition.</div>
<div>&nbsp;</div>
<div>&quot;imputed_data_helper&quot;;85150013;2880;t;&quot;AccessShareLock&quot;<br>&quot;imputed_data_helper_i1&quot;;85150013;2880;t;&quot;AccessShareLock&quot;<br>&quot;imputed_data_helper_i2&quot;;85150013;2880;t;&quot;AccessShareLock&quot;<br>
&quot;imputed_data_helper_i3&quot;;85150013;2880;t;&quot;AccessShareLock&quot;<br>&quot;imputed_data_helper_i4&quot;;85150013;2880;t;&quot;AccessShareLock&quot;<br>&quot;imputed_data_helper_pk&quot;;85150013;2880;t;&quot;AccessShareLock&quot;<br>
&quot;imputed_lane_data_07_08&quot;;85150013;2880;t;&quot;RowExclusiveLock&quot;<br>&quot;imputed_lane_data_07_08_measurement_start_i&quot;;85150013;2880;t;&quot;RowExclusiveLock&quot;<br>&quot;imputed_lane_data_07_08_pk&quot;;85150013;2880;t;&quot;RowExclusiveLock&quot;<br>
&quot;imputed_lane_data_07_08_quality_i&quot;;85150013;2880;t;&quot;RowExclusiveLock&quot;<br>&quot;imputed_prediction&quot;;85162809;1900;f;&quot;ShareUpdateExclusiveLock&quot;<br>&quot;imputed_prediction&quot;;85150013;2880;t;&quot;AccessShareLock&quot;<br>
&quot;imputed_prediction&quot;;85150013;2880;t;&quot;RowExclusiveLock&quot;<br>&quot;imputed_prediction&quot;;85150013;2880;t;&quot;ShareLock&quot;<br>&quot;imputed_prediction&quot;;85150013;2880;t;&quot;AccessExclusiveLock&quot;<br>
&quot;imputed_prediction_i1&quot;;85150013;2880;t;&quot;AccessExclusiveLock&quot;<br>&quot;imputed_prediction_i1&quot;;85150013;2880;t;&quot;AccessShareLock&quot;<br>&quot;imputed_prediction_i2&quot;;85150013;2880;t;&quot;AccessExclusiveLock&quot;<br>
&quot;imputed_prediction_i2&quot;;85150013;2880;t;&quot;AccessShareLock&quot;<br>&quot;imputed_prediction_i3&quot;;85150013;2880;t;&quot;AccessShareLock&quot;<br>&quot;imputed_prediction_i3&quot;;85150013;2880;t;&quot;AccessExclusiveLock&quot;<br>
&quot;imputed_prediction_i4&quot;;85150013;2880;t;&quot;AccessExclusiveLock&quot;<br>&quot;imputed_prediction_i4&quot;;85150013;2880;t;&quot;AccessShareLock&quot;<br>&quot;imputed_prediction_i5&quot;;85150013;2880;t;&quot;AccessExclusiveLock&quot;<br>
&quot;imputed_prediction_i5&quot;;85150013;2880;t;&quot;AccessShareLock&quot;<br>&nbsp;</div>
<div>&nbsp;</div>
<div>Sam</div>

------=_Part_47449_15288898.1216326644507--