Re: Making regression tests

"Christopher Kings-Lynne" <chriskl@familyhealth.com.au> writes:
> Just wondering if someone could give me an indication as to how to create a
> new regression test, for the ADD UNIQUE stuff I did?

It's not hard.  Make a file in src/test/regress/sql containing test
queries, and one in src/test/regress/sql/expected containing the
expected output (which is just the *actual* output, after you've
checked it over).  Add the test name to src/test/regress/serial_schedule
and src/test/regress/parallel_schedule.

If your test needs to cater for platform-dependent source or output
then things are a little harder, but I don't see why an ADD UNIQUE
test would need that.

Actually, I don't see why you wouldn't just add some more test queries
to src/test/regress/sql/alter_table.sql and corresponding output to
src/test/regress/expected/alter_table.out.  But if you really want
a separate test file, the two _schedule files are the places that
need to know about it.
        regards, tom lane