Re: Handling OID Changes in Regression Tests for C Extensions

2025-06-14 Thread Michael Paquier
On Sat, Jun 14, 2025 at 11:20:31AM -0400, Tom Lane wrote: > Tomas Vondra writes: >> The OIDs for user-defined objects (e.g. those from extensions) are not >> stable, and this will not change. The only way is to prevent the test >> output, e.g. by not including OIDs in the results, and eliminating

Re: Handling OID Changes in Regression Tests for C Extensions

2025-06-14 Thread Tom Lane
Tomas Vondra writes: > On 6/14/25 11:43, Lakshmi Narayana Velayudam wrote: >> 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

Re: Handling OID Changes in Regression Tests for C Extensions

2025-06-14 Thread Tomas Vondra
Hello Narayana, On 6/14/25 11:43, Lakshmi Narayana Velayudam wrote: > 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 m

Handling OID Changes in Regression Tests for C Extensions

2025-06-14 Thread Lakshmi Narayana Velayudam
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 mai