Dear pg-hackers,
I am facing a challenge related to OID changes in regression tests while working on a PostgreSQL C extension. Whenever I add or remove a function to the SQL file, it alters OIDs and leads to cascading modifications in multiple test files. This creates a significant overhead in maintaining the regression tests.
I would like to understand if there are best practices or tools used in PostgreSQL's own regression test suite to handle or mitigate the impact of OID changes. How does PostgreSQL manage OIDs in its tests to minimize disruption? Are there strategies, configurations, or patterns that can be recommended for extensions?
Any guidance or reference to documentation on this topic would be greatly appreciated.
Best regards,
Narayana
