Re: Show statistics target in \d+

From: Cédric Villemain <cedric(dot)villemain(dot)debian(at)gmail(dot)com>
To: Josh Kupershmidt <schmiddy(at)gmail(dot)com>
Cc: Magnus Hagander <magnus(at)hagander(dot)net>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Show statistics target in \d+
Date: 2011-11-04 14:14:22
Message-ID: CAF6yO=2aSBQ6aWXevvSqK++1+ZYHKZBN6VhkhtLcrGtponLa4g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

2011/11/4 Josh Kupershmidt <schmiddy(at)gmail(dot)com>:
> On Fri, Nov 4, 2011 at 10:05 AM, Magnus Hagander <magnus(at)hagander(dot)net> wrote:
>> On Fri, Nov 4, 2011 at 14:53, Cédric Villemain
>>> Interesting, can the ouput be clear on the value being a default or an
>>> explicit stat target ? (not mandatory but I believe I would like to
>>> have it only when the stat target is jnot the default)
>>
>> It shows -1 when it's the default.
>>
>> We could map that to the string "default" if we want, or just NULL, I
>> guess. Not sure which is best?
>
> I thought -1 was just fine. The ALTER TABLE doc page is clear that -1
> means the system default, and having another value may just confuse
> users.

yes, it looks good to me.

>
> Josh
>

--
Cédric Villemain +33 (0)6 20 30 22 52
http://2ndQuadrant.fr/
PostgreSQL: Support 24x7 - Développement, Expertise et Formation

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2011-11-04 14:19:45 Re: Show sequences owned by
Previous Message Kevin Grittner 2011-11-04 14:13:30 Re: Show statistics target in \d+