Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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)

pgsql-committers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group