Re: Show tablespace name in pg_tables and pg_indexes

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(at)mgnet(dot)de)

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(at)mgnet(dot)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(at)mgnet(dot)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(at)mgnet(dot)de)

Content-Description:

[ Attachment, skipping... ]

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

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)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(at)mgnet(dot)de)

Content-Description:

[ Attachment, skipping... ]

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

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