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
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 ... |
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 ... |
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 ... |