| From: | Richard Trice <tricer(at)asc(dot)edu> |
|---|---|
| To: | pgsql-interfaces(at)postgresql(dot)org, pgsql-novice(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org |
| Subject: | HELP: DBI and Transactions? |
| Date: | 1999-05-11 21:26:54 |
| Message-ID: | 3738A09E.6A2FCA81@asc.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-interfaces |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andy Lewis | 1999-05-12 00:30:32 | Weird datetime problem |
| Previous Message | Steve Lehr | 1999-05-11 18:21:16 |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Fischl Anton | 1999-05-11 22:51:03 | Re: |
| Previous Message | Byron Nikolaidis | 1999-05-11 18:44:57 | Re: [INTERFACES] pgAdmin interface on Windows communicating with a PostgreSQL database on Linux. |