I'm getting lots of regression failures:

========================
  25 of 89 tests failed.
========================

all pretty much looking like:

   SELECT '' AS one, o.* FROM OID_TBL o WHERE o.f1 = 1234;
! ERROR:  Relation "pg_constraint_contypid_index" does not exist
   SELECT '' AS five, o.* FROM OID_TBL o WHERE o.f1 <> '1234';

I guess a recent change requires an initdb but no change was forced?
(...an initdb does in fact fix the problem -- now only the "misc" test fails)

Joe


Fri, 22 Nov 2002 22:04:14 -0800
Joe Conway <mail@joeconway.com>
regression failures
On Sat, 2002-11-23 at 01:04, Joe Conway wrote:
> I'm getting lots of regression failures:
> 
> ========================
>   25 of 89 tests failed.
> ========================
> 
> all pretty much looking like:
> 
>    SELECT '' AS one, o.* FROM OID_TBL o WHERE o.f1 = 1234;
> ! ERROR:  Relation "pg_constraint_contypid_index" does not exist
>    SELECT '' AS five, o.* FROM OID_TBL o WHERE o.f1 <> '1234';
> 
> I guess a recent change requires an initdb but no change was forced?
> (...an initdb does in fact fix the problem -- now only the "misc" test fails)

You're right.  I added an index to pg_constraint and had completely
forgotten about it.

Sorry.  Could someone bump CATALOG_VERSION_NO?

-- 
Rod Taylor <rbt@rbt.ca>


23 Nov 2002 09:09:35 -0500
Rod Taylor <rbt@rbt.ca>
Re: regression failures
Joe Conway <mail@joeconway.com> writes:
> I guess a recent change requires an initdb but no change was forced?

There should have been a catversion bump for the domain-constraints
patch, but there wasn't.  When was your previous CVS pull?

			regards, tom lane

Sat, 23 Nov 2002 12:13:16 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: regression failures 
Tom Lane wrote:
> There should have been a catversion bump for the domain-constraints
> patch, but there wasn't.  When was your previous CVS pull?
> 

Several days ago at least. I use cvsup every few days to sync up. Is there a 
way I can tell exactly when?

Joe


Sat, 23 Nov 2002 09:28:29 -0800
Joe Conway <mail@joeconway.com>
Re: regression failures
Joe Conway <mail@joeconway.com> writes:
> Tom Lane wrote:
>> There should have been a catversion bump for the domain-constraints
>> patch, but there wasn't.  When was your previous CVS pull?

> Several days ago at least.

Then you probably got bit by that patch --- it was applied a couple days
ago.

> I use cvsup every few days to sync up. Is there a 
> way I can tell exactly when?

Dunno, I don't use cvsup.

			regards, tom lane

Sat, 23 Nov 2002 12:36:57 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: regression failures 

OK, regression tests adjusted and cat version updated.

---------------------------------------------------------------------------

Tom Lane wrote:
> Joe Conway <mail@joeconway.com> writes:
> > Tom Lane wrote:
> >> There should have been a catversion bump for the domain-constraints
> >> patch, but there wasn't.  When was your previous CVS pull?
> 
> > Several days ago at least.
> 
> Then you probably got bit by that patch --- it was applied a couple days
> ago.
> 
> > I use cvsup every few days to sync up. Is there a 
> > way I can tell exactly when?
> 
> Dunno, I don't use cvsup.
> 
> 			regards, tom lane
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
> 

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

Sat, 23 Nov 2002 13:13:26 -0500 (EST)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: regression failures