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