← 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/expected/opr_sanity.out

  • 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/expected/opr_sanity.out
1177
1177
 
1178
1178
-- Detect missing pg_amproc entries: should have as many support functions
1179
1179
-- as AM expects for each datatype combination supported by the opfamily.
 
1180
-- GiST/GIN are special cases because each has an optional support function.
1180
1181
SELECT p1.amname, p2.opfname, p3.amproclefttype, p3.amprocrighttype
1181
1182
FROM pg_am AS p1, pg_opfamily AS p2, pg_amproc AS p3
1182
1183
WHERE p2.opfmethod = p1.oid AND p3.amprocfamily = p2.oid AND
1190
1190
--------+---------+----------------+-----------------
1191
1191
(0 rows)
1192
1192
 
 
1193
-- Similar check for GiST/GIN, allowing one optional proc
1193
1194
SELECT p1.amname, p2.opfname, p3.amproclefttype, p3.amprocrighttype
1194
1195
FROM pg_am AS p1, pg_opfamily AS p2, pg_amproc AS p3
1195
1196
WHERE p2.opfmethod = p1.oid AND p3.amprocfamily = p2.oid AND
1205
1205
(0 rows)
1206
1206
 
1207
1207
-- Also, check if there are any pg_opclass entries that don't seem to have
 
1208
-- pg_amproc support.  Again, GiST/GIN have to be checked specially.
1208
1209
SELECT amname, opcname, count(*)
1209
1210
FROM pg_am am JOIN pg_opclass op ON opcmethod = am.oid
1210
1211
     LEFT JOIN pg_amproc p ON amprocfamily = opcfamily AND