Why is the is_system_table" column in the TABLES table?

[beth]

Anyone know why the "is_system_table" column is in the TABLES system table? It seems like the TABLES system tables only lists user created tables. The schemas v_catalog and v_internal are not available...

Code: Select all

dbadmin=> select count(*) from tables where is_system_table;
 count
-------
     0
(1 row)

dbadmin=> select count(*) from tables where table_schema in ('v_catalog', 'v_monitor');
 count
-------
     0
(1 row)

I just found this to be a useless column and kind of weird. I am using Vertica 7 BTW.

[JimKnicely]

Probably the same reason the "constraint_type" column is in the "primary_keys" and "foreign_keys" tables