>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 ...
Why do you want to 'partially lock the table', Nathan? It could be possible for you to actually allow inserts (from other users) while you do your housekeeping, each transaction can simply appear as a steady state. Let's say you start your transaction, read what you're interested in, deletes all rows for that particular id_user and 'reinsert'. Maybe you worry that between your SELECT and DELETE, another user adds one record. That's no problem with Firebird, as long as your SELECT and DELETE happen within the same transaction (and you use concurrency isolation), inserts from other users aren't at all visible - i.e. you can be assured that the DELETE will see exactly the same rows as your SELECT and not delete the intermediate insert (both the DELETE and SELECT will see changes done within their transaction, but not changes done by other, concurrent, transactions). Maybe there are other reasons for you to want to partially lock the table, e.g. if the SELECT and DELETE for some reason has to happen in separate transactions. If so, you (or this list) might have to come up with other solutions. HTH, Set
