It turns out that the relcache thinks it can distinguish different
Tom Lane <tgl@sss.pgh.pa.us>
It turns out that the relcache thinks it can distinguish different rules and triggers by OID. So, even though we have no cross-references in the system catalogs to pg_rewrite.oid or pg_trigger.oid, we'd better have unique indexes on them. Put back pg_rewrite_oid_index, which I mistakenly removed a few days ago, and add pg_trigger_oid_index.
Files
| Path | Change | +/− |
|---|---|---|
| src/backend/catalog/indexing.c | modified | +3 −3 |
| src/include/catalog/catversion.h | modified | +2 −2 |
| src/include/catalog/indexing.h | modified | +7 −3 |