pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedOpposite of LOCK
3+ messages / 3 participants
[nested] [flat]
* Opposite of LOCK
@ 2000-07-12 08:11 Antti Linno <alligator@all.ee>
0 siblings, 2 replies; 3+ messages in thread
From: Antti Linno @ 2000-07-12 08:11 UTC (permalink / raw)
To: pgsql-sql
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.
Antti.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Opposite of LOCK
@ 2000-07-12 11:41 Jan Wieck <JanWieck@t-online.de>
parent: Antti Linno <alligator@all.ee>
1 sibling, 0 replies; 3+ messages in thread
From: JanWieck@t-online.de @ 2000-07-12 11:41 UTC (permalink / raw)
To: Antti Linno <alligator@all.ee>; +Cc: 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@Yahoo.com #
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Opposite of LOCK
@ 2000-07-12 17:06 Tom Lane <tgl@sss.pgh.pa.us>
parent: Antti Linno <alligator@all.ee>
1 sibling, 0 replies; 3+ messages in thread
From: Tom Lane @ 2000-07-12 17:06 UTC (permalink / raw)
To: Antti Linno <alligator@all.ee>; +Cc: pgsql-sql
Antti Linno <alligator@all.ee> writes:
> 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.
Locks are released at transaction commit/abort. It has to be that way
to preserve transaction semantics. I'll refrain from commenting about
MySQL's transaction support...
regards, tom lane
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2000-07-12 17:06 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-07-12 08:11 Opposite of LOCK Antti Linno <alligator@all.ee>
2000-07-12 11:41 ` Jan Wieck <JanWieck@t-online.de>
2000-07-12 17:06 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox