newsysviews - newsysview: lots of new stuff: - "relations" views - Mailing list pgsql-committers

From andrewsn@pgfoundry.org (User Andrewsn)
Subject newsysviews - newsysview: lots of new stuff: - "relations" views
Date
Msg-id 20050409161609.BA3161FB621E@pgfoundry.org
Whole thread Raw
List 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)

pgsql-committers by date:

Previous
From: mha@pgfoundry.org (User Mha)
Date:
Subject: pginstaller - web: Add FAQ about dynamic load errors on procedural
Next
From: andreas@pgfoundry.org (User Andreas)
Date:
Subject: tablelog - tablelog: Imported Sources