Re: [BUGS] BUG #10823: Better REINDEX syntax.

From: Vik Fearing <vik(dot)fearing(at)dalibo(dot)com>
To: Marko Tiikkaja <marko(at)joh(dot)to>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Bruce Momjian <bruce(at)momjian(dot)us>, dmigowski(at)ikoffice(dot)de, PG Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [BUGS] BUG #10823: Better REINDEX syntax.
Date: 2014-09-03 12:05:50
Message-ID: 5407041E.4010309@dalibo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

On 09/02/2014 10:17 PM, Marko Tiikkaja wrote:
> On 2014-08-29 01:00, Alvaro Herrera wrote:
>> Vik Fearing wrote:
>>
>>> Here are two patches for this.
>>>
>>> The first one, reindex_user_tables.v1.patch, implements the variant that
>>> only hits user tables, as suggested by you.
>>>
>>> The second one, reindex_no_dbname.v1.patch, allows the three
>>> database-wide variants to omit the database name (voted for by Daniel
>>> Migowski, Bruce, and myself; voted against by you). This patch is to be
>>> applied on top of the first one.
>>
>> Not a fan. Here's a revised version that provides REINDEX USER TABLES,
>> which can only be used without a database name; other modes are not
>> affected i.e. they continue to require a database name.
>
> Yeah, I think I like this better than allowing all of them without the
> database name.

Why? It's just a noise word!

>> I also renamed
>> your proposed reindexdb's --usertables to --user-tables.
>
> I agree with this change.

Me, too.

>> Oh, I just noticed that if you say reindexdb --all --user-tables, the
>> latter is not honored. Must fix before commit.
>
> Definitely.

Okay, I'll look at that.

> Is someone going to prepare an updated patch? Vik?

Yes, I will update the patch.
--
Vik

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message bashtanov 2014-09-03 12:35:58 BUG #11344: ALTER TABLE ... SET SCHEMA ... do not recurse to inherited tables
Previous Message Per Wigren 2014-09-03 10:24:46 PostgreSQL 9.2.9 segfault (backtrace included)

Browse pgsql-hackers by date

  From Date Subject
Next Message Heikki Linnakangas 2014-09-03 12:09:54 Re: Escaping from blocked send() reprised.
Previous Message Heikki Linnakangas 2014-09-03 12:00:38 Re: pgcrypto: PGP signatures