пн, 11 окт. 2021 г. в 15:27, Dimitry Sibiryakov <s...@ibphoenix.com>: > > Roman Simakov wrote 11.10.2021 14:17: > > FIELD TYPE CONSTRAINT ... USING INDEX ... TABLESPACE {<TS NAME> | MAIN} -- > > field constraint tablespace > > What's the point of using "MAIN" here? Whole TABLESPACE clause cannot be > omitted? > > > Add page space id to page number in ods.h:index_root_page. > > > pag_root is located in the tablespace where a table is located > Why is this difference? What does prevent you from putting irp into the > tablespace where index is located?
IRP describes every index of a table and belongs to the table. -- Roman Simakov Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel