Subject Re: [firebird-support] Lock Conflict
Author OB1
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] <> 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>:

Thanks for replying.

Possibly. I'll recheck, but all they're doing is inserting, no selecting, editing or deletion.

We're currently testing v3.02.  v1.56 has served us extremely well.

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?