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

From Josh Kupershmidt
Subject Re: Show statistics target in \d+
Date
Msg-id CAK3UJRHZGoYUZA497syzkm9rtBspCPnW96ibcayTMzL9G0VZaQ@mail.gmail.com
Whole thread Raw
In response to Re: Show statistics target in \d+  (Magnus Hagander <magnus@hagander.net>)
Responses Re: Show statistics target in \d+
List pgsql-hackers
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.

Josh


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Show statistics target in \d+
Next
From: Stephen Frost
Date:
Subject: Re: Show statistics target in \d+