Postgres Pro
Downloads
Home   >   mailing lists

Thread: regression failures

regression failures

From
Joe Conway
Date:
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

Re: regression failures

From
Rod Taylor
Date:
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>

Re: regression failures

From
Tom Lane
Date:
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

Re: regression failures

From
Joe Conway
Date:
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

Re: regression failures

From
Tom Lane
Date:
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

Re: regression failures

From
Bruce Momjian
Date:
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,
Pennsylvania19073