Обсуждение: Patch to add objetct size on "\d+" verbose output

Поиск
Список
Период
Сортировка

Patch to add objetct size on "\d+" verbose output

От
"Dickson dos Santos Guedes"
Дата:
Hi all,

I don't know if I can post a patch here (I did subscribe to
psql-patches but without success).

Well, working in the latest revision from CVS I added a feature for
psql to the command "\d+", now it shows the object size as like as
"\l+" show the database size.

I will be pretty glad with yours sugestions and opnion.

Thanks.
--
[]s
Dickson S. Guedes
-------------------------------------
Projeto Colmeia - Curitiba - PR
(41) 3254-7130 ramal: 27
http://makeall.wordpress.com/
http://planeta.postgresql.org.br/

Вложения

Re: Patch to add objetct size on "\d+" verbose output

От
Alvaro Herrera
Дата:
Dickson dos Santos Guedes escribió:

> Well, working in the latest revision from CVS I added a feature for
> psql to the command "\d+", now it shows the object size as like as
> "\l+" show the database size.
> 

Added to May commitfest page, thanks.



-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.


Re: Patch to add objetct size on "\d+" verbose output

От
"Brendan Jurd"
Дата:
On Sat, Apr 12, 2008 at 3:53 AM, Dickson dos Santos Guedes
<guediz@gmail.com> wrote:
>  Well, working in the latest revision from CVS I added a feature for
>  psql to the command "\d+", now it shows the object size as like as
>  "\l+" show the database size.
>

I was going to try this patch out, but it would not apply.  Seems that
where the patch should have &, it has & instead.  Has this somehow
been HTML entity-ified?

Cheers,
BJ


Re: Patch to add objetct size on "\d+" verbose output

От
"Dickson dos Santos Guedes"
Дата:
On Sat, Apr 12, 2008 at 7:43 PM, Brendan Jurd <direvus@gmail.com> wrote:
>  I was going to try this patch out, but it would not apply.  Seems that
>  where the patch should have &, it has & instead.  Has this somehow
>  been HTML entity-ified?

Hi Brendan,

You are right, I don't now why this occurs. I'm sending it now
gziped, You may test it again.

Thank you.
--
[]s
Dickson S. Guedes
-------------------------------------
Projeto Colmeia - Curitiba - PR
(41) 3254-7130 ramal: 27
http://makeall.wordpress.com/
http://planeta.postgresql.org.br/

Вложения

Re: Patch to add objetct size on "\d+" verbose output

От
"Brendan Jurd"
Дата:
On Mon, Apr 14, 2008 at 8:45 AM, Dickson dos Santos Guedes
<guediz@gmail.com> wrote:
> On Sat, Apr 12, 2008 at 7:43 PM, Brendan Jurd <direvus@gmail.com> wrote:
>  >  I was going to try this patch out, but it would not apply.  Seems that
>  >  where the patch should have &, it has & instead.  Has this somehow
>  >  been HTML entity-ified?
>
>  You are right, I don't now why this occurs. I'm sending it now
>  gziped, You may test it again.
>

Hi Dickson,

I actually already corrected the '&'s manually and tested your
patch like that.  It's nice -- I think this is a very worthwhile
addition to \dt+

I note that your last email only went to -hackers; you might want to
send the updated version of your patch to -patches as well.

Cheers,
BJ


Re: Patch to add objetct size on "\d+" verbose output

От
"Heikki Linnakangas"
Дата:
Dickson dos Santos Guedes wrote:
> On Sat, Apr 12, 2008 at 7:43 PM, Brendan Jurd <direvus@gmail.com> wrote:
>>  I was going to try this patch out, but it would not apply.  Seems that
>>  where the patch should have &, it has & instead.  Has this somehow
>>  been HTML entity-ified?
> 
> Hi Brendan,
> 
> You are right, I don't now why this occurs. I'm sending it now
> gziped, You may test it again.

Although it would often be nice to see tables sorted by size, I don't 
like having a different ordering in verbose mode, that's just confusing.

Patch committed, sans the ordering change. I also moved the Size column 
before Description, I think it looks better to have the potentially long 
Description column at the end. It's also consistent with the \l+ output 
that way.

Thanks for the patch!

--   Heikki Linnakangas  EnterpriseDB   http://www.enterprisedb.com


Re: Patch to add objetct size on "\d+" verbose output

От
"Dickson dos Santos Guedes"
Дата:
On Fri, May 2, 2008 at 7:16 AM, Heikki Linnakangas
<heikki@enterprisedb.com> wrote:
>  Although it would often be nice to see tables sorted by size, I don't like
> having a different ordering in verbose mode, that's just confusing.

Yes, I agree.

> Patch committed, sans the ordering change. I also moved the Size column
> before Description, I think it looks better to have the potentially long
> Description column at the end. It's also consistent with the \l+ output that
> way.

Excelent. It is better.

> Thanks for the patch!

Thanks for your suggestions.

-- 
[]s
Dickson S. Guedes
-------------------------------------
Projeto Colmeia - Curitiba - PR
(41) 3254-7130 ramal: 27
http://makeall.wordpress.com/
http://planeta.postgresql.org.br/