Re: Opposite of LOCK - Mailing list pgsql-sql

From JanWieck@t-online.de (Jan Wieck)
Subject Re: Opposite of LOCK
Date
Msg-id 200007121141.NAA23462@hot.jw.home
Whole thread Raw
In response to Opposite of LOCK  (Antti Linno <alligator@all.ee>)
List pgsql-sql
Antti Linno wrote:
> Is there any possibility to unlock tables after they've been locked? The
> manual part of lock was fuzzy, so I ask from experts instead. MySQL
> uses lock and unlock.
   Yes, COMMIT/ROLLBACK.
   The transactional concept implies that you hold each lock you   accquired since transaction start until the
transactionends.
 


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #




pgsql-sql by date:

Previous
From: Antti Linno
Date:
Subject: Opposite of LOCK
Next
From: "Jean-Marc Libs"
Date:
Subject: Re: SERIAL type does not generate new ID ?