PG version =
"PostgreSQL 8.0.1 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.2.3
(mingw special 20030504-1)"

Attached is the regression result of my test on Pg8.0.1 win32. The problem
is quite random. On the second round, it just disappeared.


------------------------ first round --------------------------

*** ./expected/strings.out Sun Mar 14 12:25:18 2004
--- ./results/strings.out Mon Mar 14 09:51:59 2005
***************
*** 640,658 ****
--- 640,668 ----
(4 rows)

DROP TABLE toasttest;
+ ERROR: FlushRelationBuffers("pg_toast_18740", 0): block 1 is referenced
(private 0, global 1)
--
-- test substr with toasted bytea values
--
CREATE TABLE toasttest(f1 bytea);
+ ERROR: relation "toasttest" already exists
insert into toasttest values(decode(repeat('1234567890',10000),'escape') );
+ ERROR: column "f1" is of type text but expression is of type bytea
+ HINT: You will need to rewrite or cast the expression.
insert into toasttest values(decode(repeat('1234567890',10000),'escape') );
+ ERROR: column "f1" is of type text but expression is of type bytea
+ HINT: You will need to rewrite or cast the expression.
--
-- Ensure that some values are uncompressed, to test the faster substring
-- operation used in that case
--
alter table toasttest alter column f1 set storage external;
insert into toasttest values(decode(repeat('1234567890',10000),'escape') );
+ ERROR: column "f1" is of type text but expression is of type bytea
+ HINT: You will need to rewrite or cast the expression.
insert into toasttest values(decode(repeat('1234567890',10000),'escape') );
+ ERROR: column "f1" is of type text but expression is of type bytea
+ HINT: You will need to rewrite or cast the expression.
-- If the starting position is zero or less, then return from the start of
the string
-- adjusting the length to be consistent with the "negative start" per
SQL92.
SELECT substr(f1, -1, 5) from toasttest;
***************
*** 690,695 ****
--- 700,706 ----
(4 rows)

DROP TABLE toasttest;
+ ERROR: FlushRelationBuffers("pg_toast_18740", 0): block 1 is referenced
(private 0, global 1)
--
-- test length
--

================================================== ====================

*** ./expected/type_sanity.out Thu Aug 5 05:34:34 2004
--- ./results/type_sanity.out Mon Mar 14 09:52:22 2005
***************
*** 258,262 ****
(p1.attstorage != p2.typstorage AND p1.attstorage != 'p'));
attrelid | attname | oid | typname
----------+---------+-----+---------
! (0 rows)

--- 258,263 ----
(p1.attstorage != p2.typstorage AND p1.attstorage != 'p'));
attrelid | attname | oid | typname
----------+---------+-----+---------
! 18740 | f1 | 25 | text
! (1 row)


================================================== ====================

*** ./expected/misc.out Fri Mar 4 16:06:11 2005
--- ./results/misc.out Mon Mar 14 09:54:07 2005
***************
*** 658,667 ****
timestamptz_tbl
timetz_tbl
tinterval_tbl
toyemp
varchar_tbl
xacttest
! (97 rows)

SELECT name(equipment(hobby_construct(text 'skywalking', text 'mer')));
name
--- 658,668 ----
timestamptz_tbl
timetz_tbl
tinterval_tbl
+ toasttest
toyemp
varchar_tbl
xacttest
! (98 rows)

SELECT name(equipment(hobby_construct(text 'skywalking', text 'mer')));
name

================================================== ====================

*** ./expected/portals_p2.out Mon Jul 16 13:07:00 2001
--- ./results/portals_p2.out Mon Mar 14 09:54:10 2005
***************
*** 4,122 ****
BEGIN;
DECLARE foo13 CURSOR FOR
SELECT * FROM onek WHERE unique1 = 50;
DECLARE foo14 CURSOR FOR
SELECT * FROM onek WHERE unique1 = 51;
DECLARE foo15 CURSOR FOR
SELECT * FROM onek WHERE unique1 = 52;
DECLARE foo16 CURSOR FOR
SELECT * FROM onek WHERE unique1 = 53;
DECLARE foo17 CURSOR FOR
SELECT * FROM onek WHERE unique1 = 54;
DECLARE foo18 CURSOR FOR
SELECT * FROM onek WHERE unique1 = 55;
DECLARE foo19 CURSOR FOR
SELECT * FROM onek WHERE unique1 = 56;
DECLARE foo20 CURSOR FOR
SELECT * FROM onek WHERE unique1 = 57;
DECLARE foo21 CURSOR FOR
SELECT * FROM onek WHERE unique1 = 58;
DECLARE foo22 CURSOR FOR
SELECT * FROM onek WHERE unique1 = 59;
DECLARE foo23 CURSOR FOR
SELECT * FROM onek WHERE unique1 = 60;
DECLARE foo24 CURSOR FOR
SELECT * FROM onek2 WHERE unique1 = 50;
DECLARE foo25 CURSOR FOR
SELECT * FROM onek2 WHERE unique1 = 60;
FETCH all in foo13;
! unique1 | unique2 | two | four | ten | twenty | hundred | thousand |
twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 |
string4
! ---------+---------+-----+------+-----+--------+---------+----------+-----
--------+-----------+----------+-----+------+----------+----------+---------
! 50 | 253 | 0 | 2 | 0 | 10 | 0 | 50 |
50 | 50 | 50 | 0 | 1 | YBAAAA | TJAAAA | HHHHxx
! (1 row)
!
FETCH all in foo14;
! unique1 | unique2 | two | four | ten | twenty | hundred | thousand |
twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 |
string4
! ---------+---------+-----+------+-----+--------+---------+----------+-----
--------+-----------+----------+-----+------+----------+----------+---------
! 51 | 76 | 1 | 3 | 1 | 11 | 1 | 51 |
51 | 51 | 51 | 2 | 3 | ZBAAAA | YCAAAA | AAAAxx
! (1 row)
!
FETCH all in foo15;
! unique1 | unique2 | two | four | ten | twenty | hundred | thousand |
twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 |
string4
! ---------+---------+-----+------+-----+--------+---------+----------+-----
--------+-----------+----------+-----+------+----------+----------+---------
! 52 | 985 | 0 | 0 | 2 | 12 | 2 | 52 |
52 | 52 | 52 | 4 | 5 | ACAAAA | XLBAAA | HHHHxx
! (1 row)
!
FETCH all in foo16;
! unique1 | unique2 | two | four | ten | twenty | hundred | thousand |
twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 |
string4
! ---------+---------+-----+------+-----+--------+---------+----------+-----
--------+-----------+----------+-----+------+----------+----------+---------
! 53 | 196 | 1 | 1 | 3 | 13 | 3 | 53 |
53 | 53 | 53 | 6 | 7 | BCAAAA | OHAAAA | AAAAxx
! (1 row)
!
FETCH all in foo17;
! unique1 | unique2 | two | four | ten | twenty | hundred | thousand |
twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 |
string4
! ---------+---------+-----+------+-----+--------+---------+----------+-----
--------+-----------+----------+-----+------+----------+----------+---------
! 54 | 356 | 0 | 2 | 4 | 14 | 4 | 54 |
54 | 54 | 54 | 8 | 9 | CCAAAA | SNAAAA | AAAAxx
! (1 row)
!
FETCH all in foo18;
! unique1 | unique2 | two | four | ten | twenty | hundred | thousand |
twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 |
string4
! ---------+---------+-----+------+-----+--------+---------+----------+-----
--------+-----------+----------+-----+------+----------+----------+---------
! 55 | 627 | 1 | 3 | 5 | 15 | 5 | 55 |
55 | 55 | 55 | 10 | 11 | DCAAAA | DYAAAA | VVVVxx
! (1 row)
!
FETCH all in foo19;
! unique1 | unique2 | two | four | ten | twenty | hundred | thousand |
twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 |
string4
! ---------+---------+-----+------+-----+--------+---------+----------+-----
--------+-----------+----------+-----+------+----------+----------+---------
! 56 | 54 | 0 | 0 | 6 | 16 | 6 | 56 |
56 | 56 | 56 | 12 | 13 | ECAAAA | CCAAAA | OOOOxx
! (1 row)
!
FETCH all in foo20;
! unique1 | unique2 | two | four | ten | twenty | hundred | thousand |
twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 |
string4
! ---------+---------+-----+------+-----+--------+---------+----------+-----
--------+-----------+----------+-----+------+----------+----------+---------
! 57 | 942 | 1 | 1 | 7 | 17 | 7 | 57 |
57 | 57 | 57 | 14 | 15 | FCAAAA | GKBAAA | OOOOxx
! (1 row)
!
FETCH all in foo21;
! unique1 | unique2 | two | four | ten | twenty | hundred | thousand |
twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 |
string4
! ---------+---------+-----+------+-----+--------+---------+----------+-----
--------+-----------+----------+-----+------+----------+----------+---------
! 58 | 114 | 0 | 2 | 8 | 18 | 8 | 58 |
58 | 58 | 58 | 16 | 17 | GCAAAA | KEAAAA | OOOOxx
! (1 row)
!
FETCH all in foo22;
! unique1 | unique2 | two | four | ten | twenty | hundred | thousand |
twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 |
string4
! ---------+---------+-----+------+-----+--------+---------+----------+-----
--------+-----------+----------+-----+------+----------+----------+---------
! 59 | 593 | 1 | 3 | 9 | 19 | 9 | 59 |
59 | 59 | 59 | 18 | 19 | HCAAAA | VWAAAA | HHHHxx
! (1 row)
!
FETCH all in foo23;
! unique1 | unique2 | two | four | ten | twenty | hundred | thousand |
twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 |
string4
! ---------+---------+-----+------+-----+--------+---------+----------+-----
--------+-----------+----------+-----+------+----------+----------+---------
! 60 | 483 | 0 | 0 | 0 | 0 | 0 | 60 |
60 | 60 | 60 | 0 | 1 | ICAAAA | PSAAAA | VVVVxx
! (1 row)
!
FETCH all in foo24;
! unique1 | unique2 | two | four | ten | twenty | hundred | thousand |
twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 |
string4
! ---------+---------+-----+------+-----+--------+---------+----------+-----
--------+-----------+----------+-----+------+----------+----------+---------
! 50 | 253 | 0 | 2 | 0 | 10 | 0 | 50 |
50 | 50 | 50 | 0 | 1 | YBAAAA | TJAAAA | HHHHxx
! (1 row)
!
FETCH all in foo25;
! unique1 | unique2 | two | four | ten | twenty | hundred | thousand |
twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 |
string4
! ---------+---------+-----+------+-----+--------+---------+----------+-----
--------+-----------+----------+-----+------+----------+----------+---------
! 60 | 483 | 0 | 0 | 0 | 0 | 0 | 60 |
60 | 60 | 60 | 0 | 1 | ICAAAA | PSAAAA | VVVVxx
! (1 row)
!
CLOSE foo13;
CLOSE foo14;
CLOSE foo15;
CLOSE foo16;
CLOSE foo17;
CLOSE foo18;
CLOSE foo19;
CLOSE foo20;
CLOSE foo21;
CLOSE foo22;
CLOSE foo23;
CLOSE foo24;
CLOSE foo25;
END;
--- 4,96 ----
BEGIN;
DECLARE foo13 CURSOR FOR
SELECT * FROM onek WHERE unique1 = 50;
+ ERROR: could not open relation 1663/17230/16396: Invalid argument
DECLARE foo14 CURSOR FOR
SELECT * FROM onek WHERE unique1 = 51;
+ ERROR: current transaction is aborted, commands ignored until end of
transaction block
DECLARE foo15 CURSOR FOR
SELECT * FROM onek WHERE unique1 = 52;
+ ERROR: current transaction is aborted, commands ignored until end of
transaction block
DECLARE foo16 CURSOR FOR
SELECT * FROM onek WHERE unique1 = 53;
+ ERROR: current transaction is aborted, commands ignored until end of
transaction block
DECLARE foo17 CURSOR FOR
SELECT * FROM onek WHERE unique1 = 54;
+ ERROR: current transaction is aborted, commands ignored until end of
transaction block
DECLARE foo18 CURSOR FOR
SELECT * FROM onek WHERE unique1 = 55;
+ ERROR: current transaction is aborted, commands ignored until end of
transaction block
DECLARE foo19 CURSOR FOR
SELECT * FROM onek WHERE unique1 = 56;
+ ERROR: current transaction is aborted, commands ignored until end of
transaction block
DECLARE foo20 CURSOR FOR
SELECT * FROM onek WHERE unique1 = 57;
+ ERROR: current transaction is aborted, commands ignored until end of
transaction block
DECLARE foo21 CURSOR FOR
SELECT * FROM onek WHERE unique1 = 58;
+ ERROR: current transaction is aborted, commands ignored until end of
transaction block
DECLARE foo22 CURSOR FOR
SELECT * FROM onek WHERE unique1 = 59;
+ ERROR: current transaction is aborted, commands ignored until end of
transaction block
DECLARE foo23 CURSOR FOR
SELECT * FROM onek WHERE unique1 = 60;
+ ERROR: current transaction is aborted, commands ignored until end of
transaction block
DECLARE foo24 CURSOR FOR
SELECT * FROM onek2 WHERE unique1 = 50;
+ ERROR: current transaction is aborted, commands ignored until end of
transaction block
DECLARE foo25 CURSOR FOR
SELECT * FROM onek2 WHERE unique1 = 60;
+ ERROR: current transaction is aborted, commands ignored until end of
transaction block
FETCH all in foo13;
! ERROR: current transaction is aborted, commands ignored until end of
transaction block
FETCH all in foo14;
! ERROR: current transaction is aborted, commands ignored until end of
transaction block
FETCH all in foo15;
! ERROR: current transaction is aborted, commands ignored until end of
transaction block
FETCH all in foo16;
! ERROR: current transaction is aborted, commands ignored until end of
transaction block
FETCH all in foo17;
! ERROR: current transaction is aborted, commands ignored until end of
transaction block
FETCH all in foo18;
! ERROR: current transaction is aborted, commands ignored until end of
transaction block
FETCH all in foo19;
! ERROR: current transaction is aborted, commands ignored until end of
transaction block
FETCH all in foo20;
! ERROR: current transaction is aborted, commands ignored until end of
transaction block
FETCH all in foo21;
! ERROR: current transaction is aborted, commands ignored until end of
transaction block
FETCH all in foo22;
! ERROR: current transaction is aborted, commands ignored until end of
transaction block
FETCH all in foo23;
! ERROR: current transaction is aborted, commands ignored until end of
transaction block
FETCH all in foo24;
! ERROR: current transaction is aborted, commands ignored until end of
transaction block
FETCH all in foo25;
! ERROR: current transaction is aborted, commands ignored until end of
transaction block
CLOSE foo13;
+ ERROR: current transaction is aborted, commands ignored until end of
transaction block
CLOSE foo14;
+ ERROR: current transaction is aborted, commands ignored until end of
transaction block
CLOSE foo15;
+ ERROR: current transaction is aborted, commands ignored until end of
transaction block
CLOSE foo16;
+ ERROR: current transaction is aborted, commands ignored until end of
transaction block
CLOSE foo17;
+ ERROR: current transaction is aborted, commands ignored until end of
transaction block
CLOSE foo18;
+ ERROR: current transaction is aborted, commands ignored until end of
transaction block
CLOSE foo19;
+ ERROR: current transaction is aborted, commands ignored until end of
transaction block
CLOSE foo20;
+ ERROR: current transaction is aborted, commands ignored until end of
transaction block
CLOSE foo21;
+ ERROR: current transaction is aborted, commands ignored until end of
transaction block
CLOSE foo22;
+ ERROR: current transaction is aborted, commands ignored until end of
transaction block
CLOSE foo23;
+ ERROR: current transaction is aborted, commands ignored until end of
transaction block
CLOSE foo24;
+ ERROR: current transaction is aborted, commands ignored until end of
transaction block
CLOSE foo25;
+ ERROR: current transaction is aborted, commands ignored until end of
transaction block
END;

================================================== ====================

------------------------ second round --------------------------
All 96 tests passed.



---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend