newsysviews - newsysview: lots of new stuff: - "relations" views

From: andrewsn(at)pgfoundry(dot)org (User Andrewsn)
To: pgsql-committers(at)postgresql(dot)org
Subject: newsysviews - newsysview: lots of new stuff: - "relations" views
Date: 2005-04-09 16:16:09
Message-ID: 20050409161609.BA3161FB621E@pgfoundry.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

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)

Browse pgsql-committers by date

  From Date Subject
Next Message User Andreas 2005-04-09 19:38:59 tablelog - tablelog: Imported Sources
Previous Message User Mha 2005-04-09 13:36:28 pginstaller - web: Add FAQ about dynamic load errors on procedural