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 [email protected] [firebird-support] <[email protected]> wrote: > > > Are there any INSERT triggers on either of the tables? > > 2017-12-15 11:44 GMT+01:00 OB1 [email protected] > [firebird-support] <[email protected]>: > >> >> >> 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, Рустам Муса-Ахунов [email protected] >> [firebird-support] <[email protected]> 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? >>> >>> >> >> >> > >
