← Back to branch summary

~ubuntu-branches/ubuntu/oneiric/postgresql-9.1/oneiric-security

« back to all changes in this revision

Viewing changes to src/test/regress/input/constraints.source

  • Committer: Bazaar Package Importer
  • Author(s): Martin Pitt
  • Date: 2011-06-14 09:53:29 UTC
  • mto: (6.1.1 sid) (10.1.1 oneiric-proposed) (1.2.1)
  • mto: This revision was merged to the branch mainline in revision 5.
  • Revision ID: james.westby@ubuntu.com-20110614095329-71gfhjywyp2c27au
Tags: upstream-9.1~beta2
Import upstream version 9.1~beta2

Show diffs side-by-side

added added

removed removed

Lines of Context:
src/test/regress/input/constraints.source
397
397
ALTER TABLE circles ADD EXCLUDE USING gist
398
398
  (c1 WITH &&, (c2::circle) WITH &&);
399
399
 
 
400
-- try reindexing an existing constraint
 
401
REINDEX INDEX circles_c1_c2_excl;
 
402
 
400
403
DROP TABLE circles;
401
404
 
402
405
-- Check deferred exclusion constraint