Show tablespace name in pg_tables and pg_indexes

On Mon, 12 Jul 2004, Klaus Naumann wrote:

Hi,

sorry, the last patch is buggy which didn't show up in the tests :(
Two LEFTs were missing - new patch is attached.

Greetings, Klaus

Hi,

the attached patch shows the new column "tablespace" in the mentioned
views.
Apply with

~/pgsql$ patch -p1 < 03_showtblspc.diff

Greetings, Klaus

--
Full Name : Klaus Naumann | (http://www.mgnet.de/) (Germany)
Phone / FAX : ++49/177/7862964 | E-Mail: (kn@mgnet.de)

On Mon, 12 Jul 2004, Klaus Naumann wrote:

Hi,

I've sent this patch a while ago - was it applied? Is something not ok
with it? Don't want to bug anyone - just would like to have some feedback.

Grettings, Klaus

On Mon, 12 Jul 2004, Klaus Naumann wrote:

Hi,

sorry, the last patch is buggy which didn't show up in the tests :(
Two LEFTs were missing - new patch is attached.

Greetings, Klaus

Hi,

the attached patch shows the new column "tablespace" in the mentioned
views.
Apply with

~/pgsql$ patch -p1 < 03_showtblspc.diff

Greetings, Klaus

--
Full Name : Klaus Naumann | (http://www.mgnet.de/) (Germany)
Phone / FAX : ++49/177/7862964 | E-Mail: (kn@mgnet.de)

[ Previous patch discarded.]

Your patch has been added to the PostgreSQL unapplied patches list at:

http://momjian.postgresql.org/cgi-bin/pgpatches

It will be applied as soon as one of the PostgreSQL committers reviews
and approves it.

---------------------------------------------------------------------------

Klaus Naumann wrote:

On Mon, 12 Jul 2004, Klaus Naumann wrote:

Hi,

sorry, the last patch is buggy which didn't show up in the tests :(
Two LEFTs were missing - new patch is attached.

Greetings, Klaus

Hi,

the attached patch shows the new column "tablespace" in the mentioned
views.
Apply with

~/pgsql$ patch -p1 < 03_showtblspc.diff

Greetings, Klaus

--
Full Name : Klaus Naumann | (http://www.mgnet.de/) (Germany)
Phone / FAX : ++49/177/7862964 | E-Mail: (kn@mgnet.de)

Content-Description:

[ Attachment, skipping... ]

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

Patch applied and catalog version updated. We now have:

test=> select * from pg_tables;
schemaname | tablename | tablespace | tableowner | hasindexes | hasrules | hastriggers
--------------------+-------------------------+------------+------------+------------+----------+-------------
information_schema | sql_packages | | postgres | f | f | f
information_schema | sql_sizing | | postgres | f | f | f
information_schema | sql_sizing_profiles | | postgres | f | f | f
information_schema | sql_features | | postgres | f | f | f
information_schema | sql_implementation_info | | postgres | f | f | f
information_schema | sql_languages | | postgres | f | f | f
pg_catalog | pg_shadow | pg_global | postgres | t | f | t
pg_catalog | pg_opclass | | postgres | t | f | f

These columns are individually selectable so if people don't want the
column they can just skip it.

---------------------------------------------------------------------------

Klaus Naumann wrote:

On Mon, 12 Jul 2004, Klaus Naumann wrote:

Hi,

sorry, the last patch is buggy which didn't show up in the tests :(
Two LEFTs were missing - new patch is attached.

Greetings, Klaus

Hi,

the attached patch shows the new column "tablespace" in the mentioned
views.
Apply with

~/pgsql$ patch -p1 < 03_showtblspc.diff

Greetings, Klaus

--
Full Name : Klaus Naumann | (http://www.mgnet.de/) (Germany)
Phone / FAX : ++49/177/7862964 | E-Mail: (kn@mgnet.de)

Content-Description:

[ Attachment, skipping... ]

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073