Hi,
> OK, Denis, can you run the regression tests with your patch and see what
> is going on?
>
> > Bruce Momjian writes:
> > > Applied. Thanks. I know it is a pain to generate a new patch against
> > > the release.
> >
> > Regression tests opr_sanity and sanity_check are now failing.
This was due to change in template1.
Here is regression.diff attached.
And also there's test.patch attached which will fix this.
--
Sincerely Yours,
Denis Perchine
----------------------------------
E-Mail: [EMAIL PROTECTED]
HomePage: http://www.perchine.com/dyp/
FidoNet: 2:5000/120.5
----------------------------------
*** ./expected/opr_sanity.out Mon Aug 21 11:48:57 2000
--- ./results/opr_sanity.out Sun Oct 22 13:16:40 2000
***************
*** 482,489 ****
(p2.pronargs = 1 AND p1.aggbasetype = 0)));
oid | aggname | oid | proname
-------+---------+-----+-------------
! 16984 | max | 768 | int4larger
! 16998 | min | 769 | int4smaller
(2 rows)
-- Cross-check finalfn (if present) against its entry in pg_proc.
--- 482,489 ----
(p2.pronargs = 1 AND p1.aggbasetype = 0)));
oid | aggname | oid | proname
-------+---------+-----+-------------
! 16996 | max | 768 | int4larger
! 17010 | min | 769 | int4smaller
(2 rows)
-- Cross-check finalfn (if present) against its entry in pg_proc.
======================================================================
*** ./expected/sanity_check.out Thu Jul 6 06:02:37 2000
--- ./results/sanity_check.out Sun Oct 22 13:16:55 2000
***************
*** 40,45 ****
--- 40,46 ----
pg_index | t
pg_inherits | t
pg_language | t
+ pg_largeobject | t
pg_listener | t
pg_opclass | t
pg_operator | t
***************
*** 54,58 ****
shighway | t
tenk1 | t
tenk2 | t
! (44 rows)
--- 55,59 ----
shighway | t
tenk1 | t
tenk2 | t
! (45 rows)
======================================================================
Index: opr_sanity.out
===================================================================
RCS file: /home/projects/pgsql/cvsroot/pgsql/src/test/regress/expected/opr_sanity.out,v
retrieving revision 1.20
diff -u -r1.20 opr_sanity.out
--- opr_sanity.out 2000/08/21 04:48:57 1.20
+++ opr_sanity.out 2000/10/22 06:19:58
@@ -482,8 +482,8 @@
(p2.pronargs = 1 AND p1.aggbasetype = 0)));
oid | aggname | oid | proname
-------+---------+-----+-------------
- 16984 | max | 768 | int4larger
- 16998 | min | 769 | int4smaller
+ 16996 | max | 768 | int4larger
+ 17010 | min | 769 | int4smaller
(2 rows)
-- Cross-check finalfn (if present) against its entry in pg_proc.
Index: sanity_check.out
===================================================================
RCS file: /home/projects/pgsql/cvsroot/pgsql/src/test/regress/expected/sanity_check.out,v
retrieving revision 1.12
diff -u -r1.12 sanity_check.out
--- sanity_check.out 2000/07/05 23:02:37 1.12
+++ sanity_check.out 2000/10/22 06:19:58
@@ -40,6 +40,7 @@
pg_index | t
pg_inherits | t
pg_language | t
+ pg_largeobject | t
pg_listener | t
pg_opclass | t
pg_operator | t
@@ -54,5 +55,5 @@
shighway | t
tenk1 | t
tenk2 | t
-(44 rows)
+(45 rows)