regression test

On Wednesday 24 July 2002 06:13 am, stefan@extum.com wrote:

I am trying to run the regression tests under PG 7.2.1 RedHat 7.3-
I have installed PG from rpms , so from package, not source code. Right
now I have no idea if I need the source code of PG in order to start and
compile the regression tests ?

See /usr/share/doc/postgresql-7.2.1/README.rpm-dist -- it has your answers.

You will first need to see if the package 'postgresql-test' is installed -- if
not, you can get it from ftp.postgresql.org in
/pub/binary/v7.2.1/RPMS/redhat-7.3
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11

On Fri, 26 Jul 2002 stefan@extum.com wrote:

Regarding regression tests in my machine.

My box is a linux i386 Pentium III, RedHat 7.3

I was able to run the regression tests. I have got 3 tests failed
during my run. See below.

Looks like issues with timezones before epoch probably due to
the changes to mktime (IIRC) in glibc. If you're not using such times
you probably won't have to worry about it.

On Friday 26 July 2002 05:32 am, stefan@extum.com wrote:

I was able to run the regression tests. I have got 3 tests failed
during my run. See below.

abstime ... FAILED
tinterval ... FAILED
test horology ... FAILED

Looking and inspecting the regression.diffs I have got lots of things
which somebody could explain me ?

I have attached the regression.diffs . Can I make sure my PG is properly
installed in this way, having 3 steps failed ?

These are due to Red Hat's decision to change the behavior of mktime(3), which
is used in those tests for timezone. They did this without any heads up of
any kind, and now claim it was to be 'standards compliant'. A heads up would
have allowed us to made a workaround available earlier.

The solution is not to do timestamp with timezone calculations for dates prior
to 1970, until such time this problem is fixed. Red Hat believes it is not
their problem, and we believe it's not our problem. But a workaround is
possible.

You must have run the tests under the C locale, as nothing else failed.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11

On Sat, Jul 27, 2002 at 01:14:49AM +0300, stefan@extum.com wrote:

mktime(3) is different in FreeBSD than in RedHat ? Why did they changed it
? Anyway thanks for tip.

Red Hat has just changed it, because the glibc people have just
changed it. This is what POSIX hath wrought, supposedly.

Anyway, there was a recent big kerfuffle about it on this list and
others. See

<http://groups.google.com/groups?hl=en&amp;lr=&amp;ie=UTF-8&amp;selm=m34rh68465.fsf%40dep4.fciencias.unam.mx&gt;

and the resulting thread for details (sorry about the long line, but
the postgres archives haven't been working for me).

A

-- 
----
Andrew Sullivan                               87 Mowat Avenue 
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M6K 3E3
                                         +1 416 646 3304 x110

stefan@extum.com writes:

FreeBSD, RedHat, Solaris ?

Is it developed under one and ported then to other OSes, I think...

Actually the developers use a mixture of Unix flavors. Portability
issues that arise tend to be corrected very quickly. ;)

-Doug

stefan@extum.com wrote:

mktime(3) is different in FreeBSD than in RedHat ? Why did they changed it
? Anyway thanks for tip.

I wanted to ask what main Operating System the developers are
using for coding PG ?

FreeBSD, RedHat, Solaris ?

Is it developed under one and ported then to other OSes, I think...

We all use different OS's; they are all important.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

thanks for info
stefan

On Wed, 24 Jul 2002, Lamar Owen wrote:

Regarding regression tests in my machine. I crossed from general to ports
as described under /usr/share/doc/postgresql-7.2.1/README.rpm-dist

My box is a linux i386 Pentium III, RedHat 7.3

I was able to run the regression tests. I have got 3 tests failed
during my run. See below.

parallel group (20 tests): comments lseg type_sanity box reltime polygon
tinterval date point time circle path tim
etz abstime interval opr_sanity oidjoins inet timestamp timestamptz
point ... ok
lseg ... ok
box ... ok
path ... ok
polygon ... ok
circle ... ok
date ... ok
time ... ok
timetz ... ok
timestamp ... ok
timestamptz ... ok
interval ... ok
abstime ... FAILED
reltime ... ok
tinterval ... FAILED
inet ... ok
comments ... ok
oidjoins ... ok
type_sanity ... ok
opr_sanity ... ok
test geometry ... ok
test horology ... FAILED
test create_function_1 ... ok
test create_type ... ok
test create_table ... ok
test create_function_2 ... ok
test copy ... ok

Looking and inspecting the regression.diffs I have got lots of things
which somebody could explain me ?

I have attached the regression.diffs . Can I make sure my PG is properly
installed in this way, having 3 steps failed ?

stefan

On Wed, 24 Jul 2002, Lamar Owen wrote:

Regarding regression tests in my machine.

My box is a linux i386 Pentium III, RedHat 7.3

I was able to run the regression tests. I have got 3 tests failed
during my run. See below.

parallel group (20 tests): comments lseg type_sanity box reltime polygon
tinterval date point time circle path tim
etz abstime interval opr_sanity oidjoins inet timestamp timestamptz
point ... ok
lseg ... ok
box ... ok
path ... ok
polygon ... ok
circle ... ok
date ... ok
time ... ok
timetz ... ok
timestamp ... ok
timestamptz ... ok
interval ... ok
abstime ... FAILED
reltime ... ok
tinterval ... FAILED
inet ... ok
comments ... ok
oidjoins ... ok
type_sanity ... ok
opr_sanity ... ok
test geometry ... ok
test horology ... FAILED
test create_function_1 ... ok
test create_type ... ok
test create_table ... ok
test create_function_2 ... ok
test copy ... ok

Looking and inspecting the regression.diffs I have got lots of things
which I don't understand.

I have attached the regression.diffs . Can I make sure my PG is properly
installed in this way, having 3 steps failed ? Is this something to do
with my Linux OS or PG ?

stefan

On Wed, 24 Jul 2002, Lamar Owen wrote:

mktime(3) is different in FreeBSD than in RedHat ? Why did they changed it
? Anyway thanks for tip.

I wanted to ask what main Operating System the developers are
using for coding PG ?

FreeBSD, RedHat, Solaris ?

Is it developed under one and ported then to other OSes, I think...

stefan

On Thu, 25 Jul 2002, Stephan Szabo wrote: