Re: Show statistics target in \d+ - Mailing list pgsql-hackers

From Cédric Villemain
Subject Re: Show statistics target in \d+
Date
Msg-id CAF6yO=2aSBQ6aWXevvSqK++1+ZYHKZBN6VhkhtLcrGtponLa4g@mail.gmail.com
Whole thread Raw
In response to Re: Show statistics target in \d+  (Josh Kupershmidt <schmiddy@gmail.com>)
List pgsql-hackers
2011/11/4 Josh Kupershmidt <schmiddy@gmail.com>:
> On Fri, Nov 4, 2011 at 10:05 AM, Magnus Hagander <magnus@hagander.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


pgsql-hackers by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: Show statistics target in \d+
Next
From: Tom Lane
Date:
Subject: Re: Show sequences owned by