| 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 ...