Re: [COMMITTERS] pgsql: Make REINDEX DATABASE do what one would expect, - Mailing list pgsql-hackers

Do we need to adjust /contrib/reindexdb?  The README now is inaccurate,
and perhaps it should use the new syntax.

---------------------------------------------------------------------------

Tom Lane wrote:
> Log Message:
> -----------
> Make REINDEX DATABASE do what one would expect, namely reindex all indexes
> in the database.  The old behavior (reindex system catalogs only) is now
> available as REINDEX SYSTEM.  I did not add the complementary REINDEX USER
> case since there did not seem to be consensus for this, but it would be
> trivial to add later.  Per recent discussions.
> 
> Modified Files:
> --------------
>     pgsql/doc/src/sgml:
>         maintenance.sgml (r1.44 -> r1.45)
>         (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/maintenance.sgml.diff?r1=1.44&r2=1.45)
>     pgsql/doc/src/sgml/ref:
>         reindex.sgml (r1.26 -> r1.27)
>         (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/ref/reindex.sgml.diff?r1=1.26&r2=1.27)
>     pgsql/src/backend/commands:
>         indexcmds.c (r1.132 -> r1.133)
>         (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/indexcmds.c.diff?r1=1.132&r2=1.133)
>     pgsql/src/backend/nodes:
>         copyfuncs.c (r1.307 -> r1.308)
>         (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/nodes/copyfuncs.c.diff?r1=1.307&r2=1.308)
>         equalfuncs.c (r1.244 -> r1.245)
>         (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/nodes/equalfuncs.c.diff?r1=1.244&r2=1.245)
>     pgsql/src/backend/parser:
>         gram.y (r2.495 -> r2.496)
>         (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/parser/gram.y.diff?r1=2.495&r2=2.496)
>         keywords.c (r1.157 -> r1.158)
>         (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/parser/keywords.c.diff?r1=1.157&r2=1.158)
>     pgsql/src/backend/tcop:
>         utility.c (r1.237 -> r1.238)
>         (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/tcop/utility.c.diff?r1=1.237&r2=1.238)
>     pgsql/src/bin/psql:
>         common.c (r1.103 -> r1.104)
>         (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/bin/psql/common.c.diff?r1=1.103&r2=1.104)
>         tab-complete.c (r1.132 -> r1.133)
>         (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/bin/psql/tab-complete.c.diff?r1=1.132&r2=1.133)
>     pgsql/src/include/commands:
>         defrem.h (r1.64 -> r1.65)
>         (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/commands/defrem.h.diff?r1=1.64&r2=1.65)
>     pgsql/src/include/nodes:
>         parsenodes.h (r1.282 -> r1.283)
>         (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/nodes/parsenodes.h.diff?r1=1.282&r2=1.283)
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
> 

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073