"Christopher Kings-Lynne" <[EMAIL PROTECTED]> 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

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Reply via email to