Received: from asnmail.asc.edu (asnmail.asc.edu [129.66.12.7])
	by hub.org (8.9.3/8.9.3) with ESMTP id RAA86097;
	Tue, 11 May 1999 17:22:35 -0400 (EDT) (envelope-from tricer@asc.edu)
Received: from asc.edu (PC116.asc.edu [129.66.34.116])
	by asnmail.asc.edu (8.9.0.Beta5/8.9.0.Beta5) with ESMTP id JAA19453;
	Tue, 11 May 1999 09:45:29 -0500 (CDT)
Message-ID: <3738A09E.6A2FCA81@asc.edu>
Date: Tue, 11 May 1999 16:26:54 -0500
From: Richard Trice <tricer@asc.edu>
X-Mailer: Mozilla 4.04 [en] (Win95; U)
MIME-Version: 1.0
To: pgsql-interfaces@postgresql.org, pgsql-novice@postgresql.org,
	pgsql-general@postgresql.org
Subject: HELP: DBI and Transactions?
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

    I have a program that I believe needs to lock down
a table for a sequence of inserts.  I do not want anyone
inserting until I am done.  Isn't this the concept of transactions?

    I am programming in perl using DBI, and I was reading
through the ref but I don't quite get it.  Anyone familiar
with this?

Here is the general layout.

Lock table

Select max num from table;

A bunch of inserts

Unlock table.

Anyone know how?  HELP PLEASE!!!!!  I would take a good reference
if you don't have the time!

Richard Trice