|Subject||Re: [firebird-support] Lock Conflict|
Yes. A pre-insert on both that checks the data and assigns a PK from a generator if one's not assigned. Also checks valid data has been assigned and sets NEW.blah. No interaction with other tables in anyway.
On Fri, Dec 15, 2017 at 10:59 AM, Svein Erling Tysvær setysvar@... [firebird-support] <firstname.lastname@example.org> wrote:Are there any INSERT triggers on either of the tables?2017-12-15 11:44 GMT+01:00 OB1 oldbasford@... [firebird-support] <firebird-support@yahoogroups. com>:
We're currently testing v3.02. v1.56 has served us extremely well.Thanks for replying.Possibly. I'll recheck, but all they're doing is inserting, no selecting, editing or deletion.On Fri, Dec 15, 2017 at 10:04 AM, Рустам Муса-Ахунов rustam-m@... [firebird-support] <firebird-support@yahoogroups. com> wrote:How can I receive this error when inserting a new row and prior to committing?
May be, 2-nd query starts another transaction (in an unobvious way), while 1-st transaction still active.
Why do you not upgrade your Firebird and DB to 2.5 version?