What if the queries were updates instead of inserts? Would I need or be
able to lock the tables then?
Can I go without locking the bdb tables and not worry about the data
integrity on those tables during updates and inserts?
-Seth Hall
Student Programmer
Ohio State University Main Library
Is locking not necessary on BDB tables? Does transaction support get rid of
the need for table locking?
thanks,
-Seth
>On Thu, May 17, 2001 at 12:35:09PM -0400, Seth Hall wrote:
>>
>> Hi, could someone point me to a tutorial on when to do table locking
>> with th
t into Table (field1, field2) VALUES (2,'hi');
rollback;
this doesn'tit's committed anyway
begin work;
lock tables Table write;
insert into Table (field1, field2) VALUES (2,'hi');
unlock tables;
rollback;
Thanks,
Seth Hall
Stu
