This directory contains a set of tests for the serializable isolation level.

Testing isolation requires running multiple overlapping transactions,

which requires multiple concurrent connections, and can't therefore be

which requires multiple concurrent connections, andthereforecan't be

tested using the normal pg_regress program.

To run the tests, you need to have a server running at the default port

expected by libpq. (You can set PGPORT and so forth in your environment

to control this.) Then run

gmake installcheck

Note that the prepared-transactions test will not pass unless you have

the server's max_prepared_transactions parameter set to at least 3.

To represent a test with overlapping transactions, we use a test specification

file with a custom syntax, described in the next section.

file with a custom syntax,which isdescribed in the next section.

isolationtester is program that uses libpq to open multiple connections,

isolationtester isaprogram that uses libpq to open multiple connections,

and executes a test specified by a spec file. A libpq connection string

specifies the server and database to connect to; defaults derived from

environment variables are used otherwise.

pg_isolation_regress is a tool similar to pg_regress, but instead of using

psql to execute a test, it uses isolationtester.

To run the tests, you need to have a server up and running. Run

gmake installcheck

Test specification

==================