Re: CREATE SUBSCRIPTION - add missing test case

From: Heikki Linnakangas <hlinnaka(at)iki(dot)fi>
To: Peter Smith <smithpb2250(at)gmail(dot)com>, Tomas Vondra <tomas(at)vondra(dot)me>
Cc: Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, vignesh C <vignesh21(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: CREATE SUBSCRIPTION - add missing test case
Date: 2025-03-24 10:20:17
Message-ID: a59bc69b-3099-43c7-914d-47d4838e2416@iki.fi
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 10/01/2025 05:11, Peter Smith wrote:
> On Sun, Dec 8, 2024 at 10:57 AM Tomas Vondra <tomas(at)vondra(dot)me> wrote:
>> Yes, there are cases with logical replication where reproducing may be
>> expensive (in terms of data amounts, time, ...) but I don't think that's
>> the case here - this test is trivial/cheap.
>>
>> But I believe the "costs" mentioned by Amit are more about having to
>> maintain the tests etc. rather than execution costs. In which case
>> having a flag does exactly nothing - we'd still have to maintain it.
>>
>> I propose we simply add the test to 008_diff_schema.pl, per v2. I see no
>> reason to invent something more here.
>
> Hi Tomas,
>
> Since you think patch v2 is already OK as-is, I have changed the
> commitfest entry [1] for this to RfC.

Committed, thanks!

It's always a balancing act between test coverage and how long the tests
run. I agree this test is worth it, albeit with a thin margin.

--
Heikki Linnakangas
Neon (https://neon.tech)

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Shubham Khanna 2025-03-24 10:26:20 Re: Enhance 'pg_createsubscriber' to retrieve databases automatically when no database is provided.
Previous Message Andrei Lepikhov 2025-03-24 10:10:00 Re: POC, WIP: OR-clause support for indexes