Обсуждение: newsysviews - newsysview: lots of new stuff: - "relations" views
newsysviews - newsysview: lots of new stuff: - "relations" views
От
andrewsn@pgfoundry.org (User Andrewsn)
Дата:
Log Message:
-----------
lots of new stuff:
- "relations" views generalizing existing tables/views stuff
- sequences view
- table_storage view with breakdown of main/toast/index sizes
- tablespaces and tablespace contents
- schema contents
fixed incorrect handling of tablespaces in existing views; correctly handle
0 in pg_class.reltablespace as meaning "database's tablespace" rather than
just leaving it null.
Modified Files:
--------------
newsysview/sql:
_compat74.sql (r1.2 -> r1.3)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/newsysviews/newsysview/sql/_compat74.sql.diff?r1=1.2&r2=1.3)
_compat80.sql (r1.2 -> r1.3)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/newsysviews/newsysview/sql/_compat80.sql.diff?r1=1.2&r2=1.3)
_funcs.sql (r1.2 -> r1.3)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/newsysviews/newsysview/sql/_funcs.sql.diff?r1=1.2&r2=1.3)
build.sh (r1.3 -> r1.4)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/newsysviews/newsysview/sql/build.sh.diff?r1=1.3&r2=1.4)
tables.sql (r1.3 -> r1.4)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/newsysviews/newsysview/sql/tables.sql.diff?r1=1.3&r2=1.4)
types.sql (r1.2 -> r1.3)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/newsysviews/newsysview/sql/types.sql.diff?r1=1.2&r2=1.3)
views.sql (r1.2 -> r1.3)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/newsysviews/newsysview/sql/views.sql.diff?r1=1.2&r2=1.3)
Added Files:
-----------
newsysview/sql:
relations.sql (r1.1)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/newsysviews/newsysview/sql/relations.sql?rev=1.1&content-type=text/x-cvsweb-markup)
schemas.sql (r1.1)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/newsysviews/newsysview/sql/schemas.sql?rev=1.1&content-type=text/x-cvsweb-markup)
sequences.sql (r1.1)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/newsysviews/newsysview/sql/sequences.sql?rev=1.1&content-type=text/x-cvsweb-markup)
table_storage.sql (r1.1)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/newsysviews/newsysview/sql/table_storage.sql?rev=1.1&content-type=text/x-cvsweb-markup)
tablespaces.sql (r1.1)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/newsysviews/newsysview/sql/tablespaces.sql?rev=1.1&content-type=text/x-cvsweb-markup)