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 mai
> 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
https://www.tabsoverspaces.com
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
Hi *,
What do I have to do to get an error "Acquire lock for relation (XXX) failed"?
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel