Handling OID Changes in Regression Tests for C Extensions

From: Lakshmi Narayana Velayudam <dev(dot)narayana(dot)v(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Handling OID Changes in Regression Tests for C Extensions
Date: 2025-06-14 09:43:49
Message-ID: CAA4pTnJz9xHBBxyGqY_gTzRub9BYHJ1v-7bX7GN8f-abOmwOVg@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andy Fan 2025-06-14 10:24:40 Re: Improve CRC32C performance on SSE4.2
Previous Message Dilip Kumar 2025-06-14 09:32:03 Re: Proposal: Global Index for PostgreSQL