Subject | Re: Lock conflict on no wait transaction |
---|---|
Author | Svein Erling Tysvær |
Post date | 2005-07-07T11:41:23Z |
--- In firebird-support@yahoogroups.com, "pungsven" wrote:
the old version and the writer be allowed to change the record.
Rather, the problem is likely to be that the record has been changed
within one transaction that is not (yet) visible to another
transaction. This other transaction will then be denied updating the
record (or at least denied committing the transaction). So it is a
case of two writers, not one writer and one reader (though they may be
attemping to update different fields).
Set
> My question is what went wrong and how can I fix it?This should not cause any problems in Firebird, the reader should see
> I think it maybe has something to do with when one user edits a
> record while another is reading it.
the old version and the writer be allowed to change the record.
Rather, the problem is likely to be that the record has been changed
within one transaction that is not (yet) visible to another
transaction. This other transaction will then be denied updating the
record (or at least denied committing the transaction). So it is a
case of two writers, not one writer and one reader (though they may be
attemping to update different fields).
Set