| From: | JanWieck(at)t-online(dot)de (Jan Wieck) |
|---|---|
| To: | Antti Linno <alligator(at)all(dot)ee> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Opposite of LOCK |
| Date: | 2000-07-12 11:41:13 |
| Message-ID: | 200007121141.NAA23462@hot.jw.home |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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 transaction ends.
Jan
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck(at)Yahoo(dot)com #
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jean-Marc Libs | 2000-07-12 14:02:35 | Re: SERIAL type does not generate new ID ? |
| Previous Message | Antti Linno | 2000-07-12 08:11:03 | Opposite of LOCK |