Hi,

We have a few alterntive expected output files that are essentially full
of errors, because a certain feature isn't supported. Those are somewhat
painful to maintain.  I wonder if it'd be a good idea to reduce the
maintenance overhead for some of them by putting something like

SELECT NOT feature_check_expr() AS dont_have_feature
\gset
\if :dont_have_feature
\quit
\endif

at the start of such regression tests.  Then the alternative
'dont-have-the-feature' output file will stay the same when adding new
tests.

It's a bit annoying that when running such a sequence interactively one
can hit
        if (pset.cur_cmd_interactive && !active_branch &&
                !is_branching_command(cmd))
        {
                psql_error("\\%s command ignored; use \\endif or Ctrl-C to exit 
current \\if block\n",
                                   cmd);
        }
but given that's just when running interactively, it shouldn't be too
bad.

Greetings,

Andres Freund

Reply via email to