Re: pgsql-server/src/backend catalog/index.c comma ...

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Hiroshi Inoue" <inoue(at)tpf(dot)co(dot)jp>
Cc: pgsql-committers(at)postgresql(dot)org
Subject: Re: pgsql-server/src/backend catalog/index.c comma ...
Date: 2003-09-19 23:57:31
Message-ID: 12604.1064015851@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers pgsql-hackers pgsql-patches

"Hiroshi Inoue" <inoue(at)tpf(dot)co(dot)jp> writes:
>> I'd ask the question the other way: why would it be a good
>> idea to allow
>> this in REINDEX TABLE and not in the other two cases? And
>> did it really
>> work?

> Yes. I would revert your change.

You didn't answer the first question: why's this a good idea?
It seems risky and of little value to try to support system
table reindexing without disabling system indexes.

Also, your assertion that it works doesn't convince me. That business
in reindex_table about doing two setRelhasindex() calls gave me the
willies. Why was that needed? "to keep consistency with WAL" isn't
enough commentary for code as strange as that. And having a
CommandCounterIncrement() that's executed in some cases and not others
is a recipe for bugs; we've been burnt by that before.

regards, tom lane

In response to

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Hiroshi Inoue 2003-09-20 03:04:40 Re: pgsql-server/src/backend catalog/index.c comma ...
Previous Message Hiroshi Inoue 2003-09-19 23:38:42 Re: pgsql-server/src/backend catalog/index.c comma ...

Browse pgsql-hackers by date

  From Date Subject
Next Message Joshua D. Drake 2003-09-20 00:17:06 Re: PostgreSQL not ACID compliant?
Previous Message Hiroshi Inoue 2003-09-19 23:38:42 Re: pgsql-server/src/backend catalog/index.c comma ...

Browse pgsql-patches by date

  From Date Subject
Next Message Hiroshi Inoue 2003-09-20 03:04:40 Re: pgsql-server/src/backend catalog/index.c comma ...
Previous Message Hiroshi Inoue 2003-09-19 23:38:42 Re: pgsql-server/src/backend catalog/index.c comma ...