Roman Simakov wrote 06.10.2021 17:32:
A new table RDB$TABLESPACES:

  RDB$TABLESPACE_ID - SMALLINT
  RDB$TABLESPACE_NAME - CHAR (63)
  RDB$SECURITY_CLASS - CHAR (63)
  RDB$SYSTEM_FLAG - SMALLINT
  RDB$DESCRIPTION - BLOB SUBTYPE TEXT SEGMENT SIZE 80
  RDB$OWNER_NAME - CHAR (63)
  RDB$FILE_NAME - VARCHAR (255)
  RDB$OFFLINE - SMALLINT
  RDB$READ_ONLY - SMALLINT

Could you briefly describe purpose of each field? Necessity of RDB$SYSTEM_FLAG and RDB$TABLESPACE_ID at least is questionable IMHO and I see no support for OFFLINE/READ ONLY options in DDL.

A new field in RDB$RELATION_FIELDS:
   RDB$TABLESPACE_NAME - CHAR (63)

Is it possible to have in a separate tablespace some FIELDS of a table? I see no support for it in DDLs.

New fields in RDB$RELATIONS:
  RDB$TABLESPACE_NAME - CHAR (63)

  Cannot RDB$EXTERNAL_FILE be reused?

  RDB$POINTER_PAGE - INTEGER
  RDB$ROOT_PAGE - INTEGER

  What these are for?

--
  WBR, SD.


Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Reply via email to