*** /home/jcasanov/Documentos/2ndQuadrant/postgresql/src/test/regress/expected/oidjoins.out	2013-09-15 21:57:27.517958770 -0500
--- /home/jcasanov/Documentos/2ndQuadrant/postgresql/src/test/regress/results/oidjoins.out	2013-09-15 22:52:23.346301897 -0500
***************
*** 237,245 ****
  FROM	pg_catalog.pg_amproc fk
  WHERE	amproc != 0 AND
  	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.amproc);
!  ctid | amproc 
! ------+--------
! (0 rows)
  
  SELECT	ctid, adrelid
  FROM	pg_catalog.pg_attrdef fk
--- 237,246 ----
  FROM	pg_catalog.pg_amproc fk
  WHERE	amproc != 0 AND
  	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.amproc);
!   ctid  | amproc 
! --------+--------
!  (2,62) | 2187
! (1 row)
  
  SELECT	ctid, adrelid
  FROM	pg_catalog.pg_attrdef fk
***************
*** 605,613 ****
  FROM	pg_catalog.pg_opclass fk
  WHERE	opcfamily != 0 AND
  	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_opfamily pk WHERE pk.oid = fk.opcfamily);
!  ctid | opcfamily 
! ------+-----------
! (0 rows)
  
  SELECT	ctid, opcintype
  FROM	pg_catalog.pg_opclass fk
--- 606,615 ----
  FROM	pg_catalog.pg_opclass fk
  WHERE	opcfamily != 0 AND
  	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_opfamily pk WHERE pk.oid = fk.opcfamily);
!   ctid  | opcfamily 
! --------+-----------
!  (2,30) |      3045
! (1 row)
  
  SELECT	ctid, opcintype
  FROM	pg_catalog.pg_opclass fk

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

*** /home/jcasanov/Documentos/2ndQuadrant/postgresql/src/test/regress/expected/opr_sanity.out	2013-09-15 21:57:59.922119454 -0500
--- /home/jcasanov/Documentos/2ndQuadrant/postgresql/src/test/regress/results/opr_sanity.out	2013-09-15 22:52:23.710303709 -0500
***************
*** 345,353 ****
  FROM pg_proc as p1 LEFT JOIN pg_description as d
       ON p1.tableoid = d.classoid and p1.oid = d.objoid and d.objsubid = 0
  WHERE d.classoid IS NULL AND p1.oid <= 9999;
!  oid | proname 
! -----+---------
! (0 rows)
  
  -- **************** pg_cast ****************
  -- Catch bogus values in pg_cast columns (other than cases detected by
--- 345,354 ----
  FROM pg_proc as p1 LEFT JOIN pg_description as d
       ON p1.tableoid = d.classoid and p1.oid = d.objoid and d.objsubid = 0
  WHERE d.classoid IS NULL AND p1.oid <= 9999;
!  oid  |     proname     
! ------+-----------------
!  5009 | bmvacuumcleanup
! (1 row)
  
  -- **************** pg_cast ****************
  -- Catch bogus values in pg_cast columns (other than cases detected by
***************
*** 988,994 ****
                                p3.amoppurpose = 's');
   amname | amoplefttype | amoprighttype 
  --------+--------------+---------------
! (0 rows)
  
  -- Currently, none of the AMs with fixed strategy sets support ordering ops.
  SELECT p1.amname, p2.amopfamily, p2.amopstrategy
--- 989,1003 ----
                                p3.amoppurpose = 's');
   amname | amoplefttype | amoprighttype 
  --------+--------------+---------------
!  bitmap |           25 |            25
!  bitmap |           25 |            25
!  bitmap |           25 |            25
!  bitmap |           25 |            25
!  bitmap |         1042 |          1042
!  bitmap |         1042 |          1042
!  bitmap |         1042 |          1042
!  bitmap |         1042 |          1042
! (8 rows)
  
  -- Currently, none of the AMs with fixed strategy sets support ordering ops.
  SELECT p1.amname, p2.amopfamily, p2.amopstrategy
***************
*** 1098,1104 ****
         4000 |           15 | >
         4000 |           16 | @>
         4000 |           18 | =
! (62 rows)
  
  -- Check that all opclass search operators have selectivity estimators.
  -- This is not absolutely required, but it seems a reasonable thing
--- 1107,1122 ----
         4000 |           15 | >
         4000 |           16 | @>
         4000 |           18 | =
!        5013 |            1 | <
!        5013 |            1 | ~<~
!        5013 |            2 | <=
!        5013 |            2 | ~<=~
!        5013 |            3 | =
!        5013 |            3 | ~>=~
!        5013 |            4 | >=
!        5013 |            4 | ~>~
!        5013 |            5 | >
! (71 rows)
  
  -- Check that all opclass search operators have selectivity estimators.
  -- This is not absolutely required, but it seems a reasonable thing
***************
*** 1118,1126 ****
  WHERE NOT EXISTS(SELECT 1 FROM pg_amop AS p2
                   WHERE p2.amopfamily = p1.opcfamily
                     AND binary_coercible(p1.opcintype, p2.amoplefttype));
!  opcname | opcfamily 
! ---------+-----------
! (0 rows)
  
  -- Check that each operator listed in pg_amop has an associated opclass,
  -- that is one whose opcintype matches oprleft (possibly by coercion).
--- 1136,1145 ----
  WHERE NOT EXISTS(SELECT 1 FROM pg_amop AS p2
                   WHERE p2.amopfamily = p1.opcfamily
                     AND binary_coercible(p1.opcintype, p2.amoplefttype));
!      opcname      | opcfamily 
! ------------------+-----------
!  name_pattern_ops |      3045
! (1 row)
  
  -- Check that each operator listed in pg_amop has an associated opclass,
  -- that is one whose opcintype matches oprleft (possibly by coercion).
***************
*** 1135,1141 ****
                     AND binary_coercible(p2.opcintype, p1.amoplefttype));
   amopfamily | amopstrategy | amopopr 
  ------------+--------------+---------
! (0 rows)
  
  -- Operators that are primary members of opclasses must be immutable (else
  -- it suggests that the index ordering isn't fixed).  Operators that are
--- 1154,1165 ----
                     AND binary_coercible(p2.opcintype, p1.amoplefttype));
   amopfamily | amopstrategy | amopopr 
  ------------+--------------+---------
!        5024 |            1 |    2974
!        5024 |            2 |    2976
!        5024 |            3 |    2972
!        5024 |            4 |    2977
!        5024 |            5 |    2975
! (5 rows)
  
  -- Operators that are primary members of opclasses must be immutable (else
  -- it suggests that the index ordering isn't fixed).  Operators that are
***************
*** 1272,1280 ****
  WHERE am.amname <> 'btree' AND am.amname <> 'gist' AND am.amname <> 'gin'
  GROUP BY amname, amsupport, opcname, amprocfamily
  HAVING count(*) != amsupport OR amprocfamily IS NULL;
!  amname | opcname | count 
! --------+---------+-------
! (0 rows)
  
  SELECT amname, opcname, count(*)
  FROM pg_am am JOIN pg_opclass op ON opcmethod = am.oid
--- 1296,1307 ----
  WHERE am.amname <> 'btree' AND am.amname <> 'gist' AND am.amname <> 'gin'
  GROUP BY amname, amsupport, opcname, amprocfamily
  HAVING count(*) != amsupport OR amprocfamily IS NULL;
!  amname |     opcname      | count 
! --------+------------------+-------
!  bitmap | cidr_ops         |     1
!  bitmap | tinterval_ops    |     1
!  bitmap | name_pattern_ops |     1
! (3 rows)
  
  SELECT amname, opcname, count(*)
  FROM pg_am am JOIN pg_opclass op ON opcmethod = am.oid

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