Re: FIFO Queue Problems

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Wei Weng <wweng(at)kencast(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: FIFO Queue Problems
Date: 2002-11-01 19:56:32
Message-ID: 20021101195632.GA1266@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

On Fri, Nov 01, 2002 at 14:18:37 -0500,
Wei Weng <wweng(at)kencast(dot)com> wrote:
> Do you need to unlock the table fifo when you are done?

Locks only apply for the duration of a transaction. When you commit or
roleback the lock will be released.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruno Wolff III 2002-11-01 20:02:43 Re: [Q] Sequences, last_value and inserts
Previous Message Roderick A. Anderson 2002-11-01 19:50:30 [Q] Sequences, last_value and inserts

Browse pgsql-sql by date

  From Date Subject
Next Message Wei Weng 2002-11-01 20:18:01 Does this matter?
Previous Message Tom Lane 2002-11-01 19:47:44 Re: FIFO Queue Problems