Title: Re: ODP: [Firebird-devel] Inserts and FKs
tx1 starts (read commited)
tx1 INSERT INTO A (ID) VALUES (1);
tx2 starts (snapshot isolation) - How did you started tx2? If you are in isql, you need at last to run some statement, like a select, to actually start a transaction. For example, run
I have tested this and i got an error all the time or i get waiting for lock
depending on transaction settings.
I do the following:
CREATE TABLE A
(
ID BIGINT NOT null PRIMARY KEY
);
CREATE TABLE B
(
ID BIGINT NOT null PRIMARY KEY,
ID_A BIGINT NOT NULL
);
ALTER TABLE B ADD constraint FK_B__A