Received: from engine7.dnet.net.id (engine7.dnet.net.id [202.148.3.190]) by hub.org (8.8.8/8.7.5) with ESMTP id FAA15147 for ; Fri, 14 Aug 1998 05:28:05 -0400 (EDT) Received: from dnet.net.id ([202.148.1.18]) by engine7.dnet.net.id (post.office MTA v2.0 0813 ID# 0-13255) with ESMTP id AAA9552 for ; Fri, 14 Aug 1998 15:03:17 +0700 Sender: chai@.dnet.net.id Message-ID: <35D3EE21.E24F5F49@dnet.net.id> Date: Fri, 14 Aug 1998 14:58:26 +0700 From: Chairudin Sentosa Harjo X-Mailer: Mozilla 4.05 [en] (X11; I; Linux 2.0.34 i586) MIME-Version: 1.0 To: pgsql-sql@postgreSQL.org Subject: Lock vs Update References: <35D3E604.F387CD6F@uni-wuppertal.de> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi all, I have a question regarding lock. I want to update a table, so I want to make sure nobody else is trying to update the same table, that's why I use lock. What is the meaning of the NOTICE when I update the "mytable" ? ######################################### mytable=> begin; BEGIN mytable=>lock table mytable; DELETE 0 update mytable set status='INVALID' where number=12; NOTICE: (transaction aborted): queries ignored until END *ABORT STATE* ######################################### I can only update the "mytable" after I type: ######################################### mytable=> end; END mytable=> update mytable set status='INVALID' where number=12; UPDATE 1 ########################################## Regards Chai