Advanced Schema Tests

trigger_and_constraint_tests.sql

BEGIN;
SELECT plan(2);

INSERT INTO payments(1, 99, 'failed');

PREPARE insert_failure AS
INSERT INTO payments VALUES(10, -7, 'failed');

PREPARE second_failure AS
INSERT INTO policies VALUES(11, 1, 'annual');

SELECT throws_ok(
  'insert_failure',
  '23514',
  'new row for relation "payments" violates check constraint "amount_less_than_0"'
);

SELECT throws_ok(
  'second_failure',
  'P0001',
  'can only bind succeeded payments'
);

SELECT * FROM finish();
ROLLBACK;