From: | Ashish Karalkar <ashish_postgre(at)yahoo(dot)co(dot)in> |
---|---|
To: | pggeneral <pgsql-general(at)postgresql(dot)org> |
Cc: | ashish(dot)karalkar(at)netcore(dot)co(dot)in |
Subject: | Insert waiting for update? |
Date: | 2008-01-09 10:59:53 |
Message-ID: | 113240.39813.qm@web94606.mail.in2.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
<table cellspacing='0' cellpadding='0' border='0' ><tr><td style="font: inherit;">Dear list members,<br>I am having table with 4M rows.<br>I am trying to update all these rows with statement<br><br>update mytable set mycolumn=0;<br><br>At the same time there are insert happening on the table.<br>but all these insert are in waiting mode. <br>does update is locking the table for insert?<br><br>does insert and update confilict with each other?<br>With regards<br>Ashihs<br><br><br><br><br></td></tr></table><br>
<!--3--><hr size=1></hr> Save all your chat conversations. <a href="http://in.rd.yahoo.com/tagline_webmessenger_3/*http://in.messenger.yahoo.com/webmessengerpromo.php">Find them online.</a>
Attachment | Content-Type | Size |
---|---|---|
unknown_filename | text/html | 712 bytes |
From | Date | Subject | |
---|---|---|---|
Next Message | Robin-Vossen | 2008-01-09 11:02:53 | After Installing a Program I get this error: psql:sql/Pg-database.sql:825: ERROR: language "plpgsql" does not exist |
Previous Message | Harald Armin Massa | 2008-01-09 10:28:08 | Re: data transfer/migrate from win to linux |