01.02.2022 17:11, Jiří Činčura wrote:
session 1: CREATE INDEX ... ON VERY_BIG_TABLE (...); COMMIT;
Can same be achieved by selects/insert/updates and some TPB settings (like i.e.
isc_tpb_concurrency)?
Sure, but with isc_tpb_consistency (not isc_tpb_concurrency).
Dmitry
Firebird-Devel
> session 1: CREATE INDEX ... ON VERY_BIG_TABLE (...); COMMIT;
Can same be achieved by selects/insert/updates and some TPB settings (like i.e.
isc_tpb_concurrency)?
> session 2: INSERT INTO VERY_BIG_TABLE VALUES (..) -- in NO WAIT transaction
--
Mgr. Jiří Činčura
01.02.2022 16:45, Jiří Činčura wrote:
Hi *,
What do I have to do to get an error "Acquire lock for relation (XXX) failed"?
session 1: CREATE INDEX ... ON VERY_BIG_TABLE (...); COMMIT;
session 2: INSERT INTO VERY_BIG_TABLE VALUES (..) -- in NO WAIT transaction
Dmitry
Firebird-Devel mailing