Re: Include tablespace information in psql \d footers - Mailing list pgsql-patches

From Gavin Sherry
Subject Re: Include tablespace information in psql \d footers
Date
Msg-id Pine.LNX.4.58.0406290328510.24362@linuxworld.com.au
Whole thread Raw
In response to Re: Include tablespace information in psql \d footers  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Include tablespace information in psql \d footers  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-patches
On Fri, 25 Jun 2004, Tom Lane wrote:

> Gavin Sherry <swm@linuxworld.com.au> writes:
> > Attached.
>
> Couple of problems with this:
>
> 1. Don't #ifndef WIN32 it.  In the first place, we might have tablespace
> support on Windows later, and in the second place, even if psql is
> running on Windows that doesn't mean the server it's talking to is.

Oops.

>
> 2. Printing "pg_default" when reltblspace is zero is wrong.  Get the
> database's default tablespace and print that.  Or perhaps better,
> don't print anything at all; that would avoid cluttering the display
> for people who don't use tablespaces.

Ahhh yes of course. Attached is a patch with docs which excludes reporting
of the default tablespace.

Gavin

Attachment

pgsql-patches by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: plperl patch
Next
From: Simon Riggs
Date:
Subject: PITR Archive Recovery