| From: | Álvaro Herrera <alvherre(at)kurilemu(dot)de> |
|---|---|
| To: | Kirill Reshke <reshkekirill(at)gmail(dot)com> |
| Cc: | Roman Khapov <rkhapov(at)yandex-team(dot)ru>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: DROP INVALID INDEXES command |
| Date: | 2026-07-02 10:20:52 |
| Message-ID: | akTOTKF8PxZPK0qj@alvherre.pgsql |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi
BTW keep in mind that indexes on partitioned tables are transiently
marked invalid too. Your RangeVarGetRelid callback will (I think)
reject an attempt to call this on that kind of table, but it may be a
bit obscure, and you don't have any comments on why.
I still think that adding ad-hoc DDL syntax is the wrong amount of
intrusion.
--
Álvaro Herrera Breisgau, Deutschland — https://www.EnterpriseDB.com/
"Hay que recordar que la existencia en el cosmos, y particularmente la
elaboración de civilizaciones dentro de él no son, por desgracia,
nada idílicas" (Ijon Tichy)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Akshay Joshi | 2026-07-02 10:39:50 | Re: [PATCH] Add pg_get_table_ddl() to reconstruct CREATE TABLE statements |
| Previous Message | Ewan Young | 2026-07-02 10:07:26 | jsonpath .double() is a no-op on JSON numbers (differs from string input) |