Re: reindexdb command utlility - Mailing list pgsql-bugs

From Euler Taveira de Oliveira
Subject Re: reindexdb command utlility
Date
Msg-id 20060531014749.GA17578@timbira.com
Whole thread Raw
In response to reindexdb command utlility  (Henrik Zagerholm <henke@mac.se>)
Responses Re: reindexdb command utlility
Re: reindexdb command utlility
List pgsql-bugs
> I used wanted to point out the the ( -q, --quiet ) parameter for
> reindexdb command utility does not work.
Actually it is *not* a bug. The NOTICE is printed by the REINDEX
command; reindexdb is just a wrapper around REINDEX command. If you
set up 'client_min_messages' in postgresql.conf, you don't get those
'annoying' messages.

> Also reindexdb writes NOTICE to standard err for every table it
> reindexes which makes it really hard to use in script as it always
> produces an "errror".  :-)
>
You can always ignore NOTICE. grep is your friend. :-)

Looking at the code, IMHO we could raise the ereport from NOTICE to
INFO (see the patch attached). None of the scripts actually raise
NOTICEs if it succeeds.

Comments?


--
  Euler Taveira de Oliveira
  http://www.timbira.com/

Attachment

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: strange (numeric) casting behaviour
Next
From: Harco de Hilster
Date:
Subject: Re: pg_restore problem