| From: | Michael Paquier <michael(at)paquier(dot)xyz> |
|---|---|
| To: | richard(dot)vesely(at)softea(dot)sk, pgsql-bugs(at)lists(dot)postgresql(dot)org |
| Subject: | Re: BUG #18016: REINDEX TABLE failure |
| Date: | 2023-07-08 00:17:21 |
| Message-ID: | ZKirERBzkM48E0op@paquier.xyz |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-hackers |
On Thu, Jul 06, 2023 at 08:29:19PM +0000, PG Bug reporting form wrote:
> Given a table with a TOASTed variable length attribute, REINDEX TABLE fails
> to rebuild indexes when you truncate (or otherwise corrupt) relation files
> for both TOAST table index and a custom index on the varlena.
Could you clarify what you have done here? Did you manipulate the
physical files in the data folder before running the REINDEX commands
you expected should work? There are many things that can go wrong if
you do anything like that.
--
Michael
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2023-07-08 00:20:01 | Re: BUG #18016: REINDEX TABLE failure |
| Previous Message | Michael Paquier | 2023-07-08 00:05:26 | Re: pg_basebackup: errors on macOS on directories with ".DS_Store" files |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2023-07-08 00:20:01 | Re: BUG #18016: REINDEX TABLE failure |
| Previous Message | Michael Paquier | 2023-07-07 23:47:21 | Re: Add more sanity checks around callers of changeDependencyFor() |