Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 7F6FC474E53 for ; Fri, 1 Nov 2002 14:47:12 -0500 (EST) Received: from wolff.to (unknown [66.93.197.35]) by postgresql.org (Postfix) with SMTP id C4186474E44 for ; Fri, 1 Nov 2002 14:47:11 -0500 (EST) Received: (qmail 1298 invoked by uid 500); 1 Nov 2002 19:56:32 -0000 Date: Fri, 1 Nov 2002 13:56:32 -0600 From: Bruno Wolff III To: Wei Weng Cc: pgsql-sql@postgresql.org Subject: Re: FIFO Queue Problems Message-ID: <20021101195632.GA1266@wolff.to> Mail-Followup-To: Wei Weng , pgsql-sql@postgresql.org References: <20021101145630.50886.qmail@web13801.mail.yahoo.com> <26900.1036169461@sss.pgh.pa.us> <1036178317.23296.2.camel@Monet> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <1036178317.23296.2.camel@Monet> User-Agent: Mutt/1.3.25i X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200211/16 X-Sequence-Number: 10158 On Fri, Nov 01, 2002 at 14:18:37 -0500, Wei Weng 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.