pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Opposite 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