Subject | lock the table "partially" |
---|---|
Author | nathanelrick |
Post date | 2012-02-16T07:26:06Z |
Hello,
i m in multi user database.
I want to clean a table of all entries from one user (rec with field id_user=xxx) and insert new entries, BUT i must be sure that noone is not actually doing any insert on this table for this user. i can not lock the table because this will affect all the users, i just need to lock all insert with id_user=xxx
is this possible in firebird ?
at the end yes i will lock the table but if i can avoid it ...
i m in multi user database.
I want to clean a table of all entries from one user (rec with field id_user=xxx) and insert new entries, BUT i must be sure that noone is not actually doing any insert on this table for this user. i can not lock the table because this will affect all the users, i just need to lock all insert with id_user=xxx
is this possible in firebird ?
at the end yes i will lock the table but if i can avoid it ...