Re: [INTERFACES] Problem with regression test - Mailing list pgsql-interfaces

From Tom Lane
Subject Re: [INTERFACES] Problem with regression test
Date
Msg-id 21908.930751570@sss.pgh.pa.us
Whole thread Raw
In response to Problem with regression test  (Jim Lemon <Jim.Lemon@uts.EDU.AU>)
List pgsql-interfaces
Jim Lemon <Jim.Lemon@uts.EDU.AU> writes:
> Regression test failed at this point:
> ...
> select_views .. ok
> alter_table .. ERROR:  Unable to locate type name 'dt' in catalog
> ERROR:  Relation 'tmp' does not have attribute 'k'
> ERROR:  Unable to locate type name 'dt' in catalog
> ERROR:  Relation 'tmp' does not have attribute 'k'
> ok

These "ERROR" messages are in fact normal log output during the
regression test ... but they shouldn't be appearing on your screen!
I think that when you started the postmaster, you forgot to redirect
its stdout and stderr into a log file per the instructions.  The
regression tests will usually generate something like 50K of log output
(since they deliberately provoke a lot of errors...)

> rules .. failed

That's a little more disturbing, but you'll need to look at the
regression.diffs output to see if the difference is actually meaningful.
I suspect there are still a few queries in the rules test wherein the
order in which tuples are displayed is platform-dependent ... don't
worry about it if the differences turn out to look like that.

> at this point, the program apparently hung (using over 90% CPU) for
> several minutes, until I killed the 'regression' process as root.

Patience, my boy ... the last 'numeric' test is pretty slow, but it's
not hung.
        regards, tom lane


pgsql-interfaces by date:

Previous
From: Thomas Lockhart
Date:
Subject: Re: [INTERFACES] Problem with regression test
Next
From: Dave Page
Date:
Subject: RE: [INTERFACES] ODBC: OID column in views