After experiencing so many problems with 7.3.2, I decided to test
7.4-snapshot. It failed only on one test, instead of 17.
NetBSD-1.6 / Alpha (64-bit)
Postgresql-7.4-snapshot-2003-03-24
The error I'm getting is:
! ERROR: datumGetSize: Invalid typLen 0
That error caused many problems in 7.3.2. I sent an email about this but
it must be stuck in the queue because it had an attachment of 234k.
---------------------------
*** ./expected/opr_sanity.out Tue Jan 28 16:13:41 2003
--- ./results/opr_sanity.out Wed Mar 26 22:08:17 2003
***************
*** 46,55 ****
p1.proname = p2.proname AND
p1.pronargs = p2.pronargs AND
p1.proargtypes = p2.proargtypes;
! oid | proname | oid | proname
! -----+---------+-----+---------
! (0 rows)
!
-- Considering only built-in procs (prolang = 12), look for multiple
uses
-- of the same internal function (ie, matching prosrc fields). It's OK
to
-- have several entries with different pronames for the same internal
function,
--- 46,52 ----
p1.proname = p2.proname AND
p1.pronargs = p2.pronargs AND
p1.proargtypes = p2.proargtypes;
! ERROR: datumGetSize: Invalid typLen 0
-- Considering only built-in procs (prolang = 12), look for multiple
uses
-- of the same internal function (ie, matching prosrc fields). It's OK
to
-- have several entries with different pronames for the same internal
function,
***************
*** 276,285 ****
p1.oprkind = p2.oprkind AND
p1.oprleft = p2.oprleft AND
p1.oprright = p2.oprright;
! oid | oprcode | oid | oprcode
! -----+---------+-----+---------
! (0 rows)
!
-- Look for commutative operators that don't commute.
-- DEFINITIONAL NOTE: If A.oprcom = B, then x A y has the same result as
y B x.
-- We expect that B will always say that B.oprcom = A as well; that's
not
--- 273,279 ----
p1.oprkind = p2.oprkind AND
p1.oprleft = p2.oprleft AND
p1.oprright = p2.oprright;
! ERROR: datumGetSize: Invalid typLen 0
-- Look for commutative operators that don't commute.
-- DEFINITIONAL NOTE: If A.oprcom = B, then x A y has the same result as
y B x.
-- We expect that B will always say that B.oprcom = A as well; that's
not
======================================================================
--
Thomas
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html