regress test errors

From: <mjbjr(at)beaudesign(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: regress test errors
Date: 2001-03-21 23:50:03
Message-ID: Pine.LNX.4.10.10103211528050.12113-100000@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have installed all 10 postgresql-7.0.3-2 rpm's. AFAICT, they have
installed fine. Doing the regression test, I got many errors. Most of
these are not mentioned by the regress "README" file as intentional,
platform, or known. I'm hoping that the README is deficient vis-a-vis
7.0.3-2.

I would be interested in opinions of the errors by the pg guru's that
frequent this ng.

Below is a 'grep ERROR' on the 'regression.diffs' file:

+ ERROR: TypeCreate: function 'widget_in(opaque)' does not exist
+ ERROR: CreateTrigger: function check_primary_key() does not exist
+ ERROR: CreateTrigger: function check_primary_key() does not exist
+ ERROR: CreateTrigger: function check_primary_key() does not exist
+ ERROR: CreateTrigger: function check_foreign_key() does not exist
- ERROR: check_fkeys2_pkey_exist: tuple references non-existing key in
pkeys
- ERROR: check_fkeys_pkey_exist: tuple references non-existing key in
pkeys
- ERROR: check_fkeys_pkey2_exist: tuple references non-existing key in
fkeys2
- ERROR: check_fkeys2_fkey_restrict: tuple referenced in fkeys
- ERROR: check_fkeys2_fkey_restrict: tuple referenced in fkeys
+ ERROR: CreateTrigger: function check_foreign_key() does not exist
! ERROR: Cannot insert a duplicate key into unique index pkeys_i
+ ERROR: CreateTrigger: function ttdummy() does not exist
+ ERROR: CreateTrigger: function autoinc() does not exist
- ERROR: ttdummy (tttest): you can't change price_on and/or price_off
columns (use set_ttdummy)
! ERROR: Function 'set_ttdummy(int4)' does not exist
! ERROR: Function 'set_ttdummy(int4)' does not exist
! ERROR: Function 'set_ttdummy(int4)' does not exist
+ ERROR: OperatorGet: right type 'widget' nonexistent
+ ERROR: Function 'interpt_pp(path, path)' does not exist
! ERROR: floating point exception! The last floating point operation
either exceeded legal ranges or was a divide by zero
! ERROR: Relation 'iexit' does not exist
+ ERROR: Relation 'tmp' already exists
ERROR: Relation 'tmp' does not have attribute 'k'
ERROR: Relation 'tmp' does not have attribute 'k'

Additional errors are similiar to:

expected: ! | 456.000
result: ! | $ 456.000

the diff being the '$', which I hope to be inconsequential.

I'd appreciate opinions to whether my pg install on RH6.1 is messed up.

Thank you.

- Martin J. Brown, Jr. -
- mjbjr(at)beaudesign(dot)com -

PGP Public Key ID: 0xCED9BD8A Key Server: http://www.keyserver.net/en/

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Feite Brekeveld 2001-03-21 23:50:11 after trigger question
Previous Message Patrick Welche 2001-03-21 23:43:08 Re: libpq++: how do I qualify by table name a resulting field when there are duplicate field names