Jan Wieck <[EMAIL PROTECTED]> writes:
> That's strange, if I reverse apply my patch I have buffer leak's and all 
> kinds of crap. Can't even initdb. Who else applied patches tonight?

FWIW, I can initdb --- that seems fine --- but the regression tests spew
lots of small fragments.  What I suspect is that the bufmgr is
occasionally returning the wrong buffer :-(

regression.diffs attached.  Also, "grep TRAP postmaster.log" shows
this is the cause of the coredump midway through:

TRAP: FailedAssertion("!(( (&(cdb_replace->buf_tag))->rnode.tblNode == 
(&(buf->tag))->rnode.tblNode && (&(cdb_replace->buf_tag))->rnode.relNode == 
(&(buf->tag))->rnode.relNode && (&(cdb_replace->buf_tag))->blockNum == 
(&(buf->tag))->blockNum ))", File: "freelist.c", Line: 610)

Note this is with a serial test (make installcheck).  Chris' very
different-looking results may be because he was doing parallel tests;
or there might be something else involved.

                        regards, tom lane


*** ./expected/name.out Sun May 25 20:11:28 2003
--- ./results/name.out  Wed Nov 12 22:16:27 2003
***************
*** 90,126 ****
  (6 rows)
  
  SELECT '' AS seven, c.f1 FROM NAME_TBL c WHERE c.f1 ~ '.*';
!  seven |                               f1                                
! -------+-----------------------------------------------------------------
!        | 1234567890ABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890ABCDEFGHIJKLMNOPQ
!        | 1234567890abcdefghijklmnopqrstuvwxyz1234567890abcdefghijklmnopq
!        | asdfghjkl;
!        | 343f%2a
!        | d34aaasdf
!        | 
!        | 1234567890ABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890ABCDEFGHIJKLMNOPQ
! (7 rows)
! 
  SELECT '' AS zero, c.f1 FROM NAME_TBL c WHERE c.f1 !~ '.*';
!  zero | f1 
! ------+----
! (0 rows)
! 
  SELECT '' AS three, c.f1 FROM NAME_TBL c WHERE c.f1 ~ '[0-9]';
!  three |                               f1                                
! -------+-----------------------------------------------------------------
!        | 1234567890ABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890ABCDEFGHIJKLMNOPQ
!        | 1234567890abcdefghijklmnopqrstuvwxyz1234567890abcdefghijklmnopq
!        | 343f%2a
!        | d34aaasdf
!        | 1234567890ABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890ABCDEFGHIJKLMNOPQ
! (5 rows)
! 
  SELECT '' AS two, c.f1 FROM NAME_TBL c WHERE c.f1 ~ '.*asdf.*';
!  two |     f1     
! -----+------------
!      | asdfghjkl;
!      | d34aaasdf
! (2 rows)
! 
  DROP TABLE NAME_TBL;
--- 90,104 ----
  (6 rows)
  
  SELECT '' AS seven, c.f1 FROM NAME_TBL c WHERE c.f1 ~ '.*';
! ERROR:  could not access status of transaction 2752512
! DETAIL:  could not open file "/home/tgl/testversion/data/pg_clog/0002": No such file 
or directory
  SELECT '' AS zero, c.f1 FROM NAME_TBL c WHERE c.f1 !~ '.*';
! ERROR:  could not access status of transaction 2752512
! DETAIL:  could not open file "/home/tgl/testversion/data/pg_clog/0002": No such file 
or directory
  SELECT '' AS three, c.f1 FROM NAME_TBL c WHERE c.f1 ~ '[0-9]';
! ERROR:  could not access status of transaction 2752512
! DETAIL:  could not open file "/home/tgl/testversion/data/pg_clog/0002": No such file 
or directory
  SELECT '' AS two, c.f1 FROM NAME_TBL c WHERE c.f1 ~ '.*asdf.*';
! ERROR:  could not access status of transaction 2752512
! DETAIL:  could not open file "/home/tgl/testversion/data/pg_clog/0002": No such file 
or directory
  DROP TABLE NAME_TBL;

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

*** ./expected/varchar.out      Mon May 21 12:54:46 2001
--- ./results/varchar.out       Wed Nov 12 22:16:27 2003
***************
*** 2,111 ****
  -- VARCHAR
  --
  CREATE TABLE VARCHAR_TBL(f1 varchar(1));
  INSERT INTO VARCHAR_TBL (f1) VALUES ('a');
  INSERT INTO VARCHAR_TBL (f1) VALUES ('A');
  -- any of the following three input formats are acceptable 
  INSERT INTO VARCHAR_TBL (f1) VALUES ('1');
  INSERT INTO VARCHAR_TBL (f1) VALUES (2);
  INSERT INTO VARCHAR_TBL (f1) VALUES ('3');
  -- zero-length char 
  INSERT INTO VARCHAR_TBL (f1) VALUES ('');
  -- try varchar's of greater than 1 length 
  INSERT INTO VARCHAR_TBL (f1) VALUES ('cd');
! ERROR:  value too long for type character varying(1)
  INSERT INTO VARCHAR_TBL (f1) VALUES ('c     ');
  SELECT '' AS seven, VARCHAR_TBL.*;
!  seven | f1 
! -------+----
!        | a
!        | A
!        | 1
!        | 2
!        | 3
!        | 
!        | c
! (7 rows)
! 
  SELECT '' AS six, c.*
     FROM VARCHAR_TBL c
     WHERE c.f1 <> 'a';
!  six | f1 
! -----+----
!      | A
!      | 1
!      | 2
!      | 3
!      | 
!      | c
! (6 rows)
! 
  SELECT '' AS one, c.*
     FROM VARCHAR_TBL c
     WHERE c.f1 = 'a';
!  one | f1 
! -----+----
!      | a
! (1 row)
! 
  SELECT '' AS five, c.*
     FROM VARCHAR_TBL c
     WHERE c.f1 < 'a';
!  five | f1 
! ------+----
!       | A
!       | 1
!       | 2
!       | 3
!       | 
! (5 rows)
! 
  SELECT '' AS six, c.*
     FROM VARCHAR_TBL c
     WHERE c.f1 <= 'a';
!  six | f1 
! -----+----
!      | a
!      | A
!      | 1
!      | 2
!      | 3
!      | 
! (6 rows)
! 
  SELECT '' AS one, c.*
     FROM VARCHAR_TBL c
     WHERE c.f1 > 'a';
!  one | f1 
! -----+----
!      | c
! (1 row)
! 
  SELECT '' AS two, c.*
     FROM VARCHAR_TBL c
     WHERE c.f1 >= 'a';
!  two | f1 
! -----+----
!      | a
!      | c
! (2 rows)
! 
  DROP TABLE VARCHAR_TBL;
  --
  -- Now test longer arrays of char
  --
  CREATE TABLE VARCHAR_TBL(f1 varchar(4));
  INSERT INTO VARCHAR_TBL (f1) VALUES ('a');
  INSERT INTO VARCHAR_TBL (f1) VALUES ('ab');
  INSERT INTO VARCHAR_TBL (f1) VALUES ('abcd');
  INSERT INTO VARCHAR_TBL (f1) VALUES ('abcde');
! ERROR:  value too long for type character varying(4)
  INSERT INTO VARCHAR_TBL (f1) VALUES ('abcd    ');
  SELECT '' AS four, VARCHAR_TBL.*;
!  four |  f1  
! ------+------
!       | a
!       | ab
!       | abcd
!       | abcd
! (4 rows)
! 
--- 2,70 ----
  -- VARCHAR
  --
  CREATE TABLE VARCHAR_TBL(f1 varchar(1));
+ ERROR:  could not access status of transaction 2752512
+ DETAIL:  could not open file "/home/tgl/testversion/data/pg_clog/0002": No such file 
or directory
  INSERT INTO VARCHAR_TBL (f1) VALUES ('a');
+ ERROR:  relation "varchar_tbl" does not exist
  INSERT INTO VARCHAR_TBL (f1) VALUES ('A');
+ ERROR:  relation "varchar_tbl" does not exist
  -- any of the following three input formats are acceptable 
  INSERT INTO VARCHAR_TBL (f1) VALUES ('1');
+ ERROR:  relation "varchar_tbl" does not exist
  INSERT INTO VARCHAR_TBL (f1) VALUES (2);
+ ERROR:  relation "varchar_tbl" does not exist
  INSERT INTO VARCHAR_TBL (f1) VALUES ('3');
+ ERROR:  relation "varchar_tbl" does not exist
  -- zero-length char 
  INSERT INTO VARCHAR_TBL (f1) VALUES ('');
+ ERROR:  relation "varchar_tbl" does not exist
  -- try varchar's of greater than 1 length 
  INSERT INTO VARCHAR_TBL (f1) VALUES ('cd');
! ERROR:  relation "varchar_tbl" does not exist
  INSERT INTO VARCHAR_TBL (f1) VALUES ('c     ');
+ ERROR:  relation "varchar_tbl" does not exist
  SELECT '' AS seven, VARCHAR_TBL.*;
! ERROR:  relation "varchar_tbl" does not exist
  SELECT '' AS six, c.*
     FROM VARCHAR_TBL c
     WHERE c.f1 <> 'a';
! ERROR:  relation "varchar_tbl" does not exist
  SELECT '' AS one, c.*
     FROM VARCHAR_TBL c
     WHERE c.f1 = 'a';
! ERROR:  relation "varchar_tbl" does not exist
  SELECT '' AS five, c.*
     FROM VARCHAR_TBL c
     WHERE c.f1 < 'a';
! ERROR:  relation "varchar_tbl" does not exist
  SELECT '' AS six, c.*
     FROM VARCHAR_TBL c
     WHERE c.f1 <= 'a';
! ERROR:  relation "varchar_tbl" does not exist
  SELECT '' AS one, c.*
     FROM VARCHAR_TBL c
     WHERE c.f1 > 'a';
! ERROR:  relation "varchar_tbl" does not exist
  SELECT '' AS two, c.*
     FROM VARCHAR_TBL c
     WHERE c.f1 >= 'a';
! ERROR:  relation "varchar_tbl" does not exist
  DROP TABLE VARCHAR_TBL;
+ ERROR:  table "varchar_tbl" does not exist
  --
  -- Now test longer arrays of char
  --
  CREATE TABLE VARCHAR_TBL(f1 varchar(4));
+ ERROR:  type "pg_catalog.varchar" does not exist
  INSERT INTO VARCHAR_TBL (f1) VALUES ('a');
+ ERROR:  relation "varchar_tbl" does not exist
  INSERT INTO VARCHAR_TBL (f1) VALUES ('ab');
+ ERROR:  relation "varchar_tbl" does not exist
  INSERT INTO VARCHAR_TBL (f1) VALUES ('abcd');
+ ERROR:  relation "varchar_tbl" does not exist
  INSERT INTO VARCHAR_TBL (f1) VALUES ('abcde');
! ERROR:  relation "varchar_tbl" does not exist
  INSERT INTO VARCHAR_TBL (f1) VALUES ('abcd    ');
+ ERROR:  relation "varchar_tbl" does not exist
  SELECT '' AS four, VARCHAR_TBL.*;
! ERROR:  relation "varchar_tbl" does not exist

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

*** ./expected/text.out Tue Jan  4 11:19:34 2000
--- ./results/text.out  Wed Nov 12 22:16:27 2003
***************
*** 2,25 ****
  -- TEXT
  --
  SELECT text 'this is a text string' = text 'this is a text string' AS true;
!  true 
! ------
!  t
! (1 row)
! 
  SELECT text 'this is a text string' = text 'this is a text strin' AS false;
!  false 
! -------
!  f
! (1 row)
! 
  CREATE TABLE TEXT_TBL (f1 text);
  INSERT INTO TEXT_TBL VALUES ('doh!');
  INSERT INTO TEXT_TBL VALUES ('hi de ho neighbor');
  SELECT '' AS two, * FROM TEXT_TBL;
!  two |        f1         
! -----+-------------------
!      | doh!
!      | hi de ho neighbor
! (2 rows)
! 
--- 2,15 ----
  -- TEXT
  --
  SELECT text 'this is a text string' = text 'this is a text string' AS true;
! ERROR:  type "text" does not exist
  SELECT text 'this is a text string' = text 'this is a text strin' AS false;
! ERROR:  type "text" does not exist
  CREATE TABLE TEXT_TBL (f1 text);
+ ERROR:  type "text" does not exist
  INSERT INTO TEXT_TBL VALUES ('doh!');
+ ERROR:  relation "text_tbl" does not exist
  INSERT INTO TEXT_TBL VALUES ('hi de ho neighbor');
+ ERROR:  relation "text_tbl" does not exist
  SELECT '' AS two, * FROM TEXT_TBL;
! ERROR:  relation "text_tbl" does not exist

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

*** ./expected/int8.out Thu Mar 27 11:35:31 2003
--- ./results/int8.out  Wed Nov 12 22:16:27 2003
***************
*** 111,285 ****
  --
  SELECT '' AS to_char_1, to_char(q1, '9G999G999G999G999G999'), to_char(q2, 
'9,999,999,999,999,999') 
        FROM INT8_TBL;
!  to_char_1 |        to_char         |        to_char         
! -----------+------------------------+------------------------
!            |                    123 |                    456
!            |                    123 |  4,567,890,123,456,789
!            |  4,567,890,123,456,789 |                    123
!            |  4,567,890,123,456,789 |  4,567,890,123,456,789
!            |  4,567,890,123,456,789 | -4,567,890,123,456,789
! (5 rows)
! 
  SELECT '' AS to_char_2, to_char(q1, '9G999G999G999G999G999D999G999'), to_char(q2, 
'9,999,999,999,999,999.999,999') 
        FROM INT8_TBL;  
!  to_char_2 |            to_char             |            to_char             
! -----------+--------------------------------+--------------------------------
!            |                    123.000,000 |                    456.000,000
!            |                    123.000,000 |  4,567,890,123,456,789.000,000
!            |  4,567,890,123,456,789.000,000 |                    123.000,000
!            |  4,567,890,123,456,789.000,000 |  4,567,890,123,456,789.000,000
!            |  4,567,890,123,456,789.000,000 | -4,567,890,123,456,789.000,000
! (5 rows)
! 
  SELECT '' AS to_char_3, to_char( (q1 * -1), '9999999999999999PR'), to_char( (q2 * 
-1), '9999999999999999.999PR') 
        FROM INT8_TBL;
!  to_char_3 |      to_char       |        to_char         
! -----------+--------------------+------------------------
!            |              <123> |              <456.000>
!            |              <123> | <4567890123456789.000>
!            | <4567890123456789> |              <123.000>
!            | <4567890123456789> | <4567890123456789.000>
!            | <4567890123456789> |  4567890123456789.000 
! (5 rows)
! 
  SELECT '' AS to_char_4, to_char( (q1 * -1), '9999999999999999S'), to_char( (q2 * 
-1), 'S9999999999999999') 
        FROM INT8_TBL;
!  to_char_4 |      to_char      |      to_char      
! -----------+-------------------+-------------------
!            |              123- |              -456
!            |              123- | -4567890123456789
!            | 4567890123456789- |              -123
!            | 4567890123456789- | -4567890123456789
!            | 4567890123456789- | +4567890123456789
! (5 rows)
! 
  SELECT '' AS to_char_5,  to_char(q2, 'MI9999999999999999')     FROM INT8_TBL; 
!  to_char_5 |      to_char      
! -----------+-------------------
!            |               456
!            |  4567890123456789
!            |               123
!            |  4567890123456789
!            | -4567890123456789
! (5 rows)
! 
  SELECT '' AS to_char_6,  to_char(q2, 'FMS9999999999999999')    FROM INT8_TBL;
!  to_char_6 |      to_char      
! -----------+-------------------
!            | +456
!            | +4567890123456789
!            | +123
!            | +4567890123456789
!            | -4567890123456789
! (5 rows)
! 
  SELECT '' AS to_char_7,  to_char(q2, 'FM9999999999999999THPR') FROM INT8_TBL;
!  to_char_7 |      to_char       
! -----------+--------------------
!            | 456TH
!            | 4567890123456789TH
!            | 123RD
!            | 4567890123456789TH
!            | <4567890123456789>
! (5 rows)
! 
  SELECT '' AS to_char_8,  to_char(q2, 'SG9999999999999999th')   FROM INT8_TBL; 
!  to_char_8 |       to_char       
! -----------+---------------------
!            | +             456th
!            | +4567890123456789th
!            | +             123rd
!            | +4567890123456789th
!            | -4567890123456789
! (5 rows)
! 
  SELECT '' AS to_char_9,  to_char(q2, '0999999999999999')       FROM INT8_TBL; 
!  to_char_9 |      to_char      
! -----------+-------------------
!            |  0000000000000456
!            |  4567890123456789
!            |  0000000000000123
!            |  4567890123456789
!            | -4567890123456789
! (5 rows)
! 
  SELECT '' AS to_char_10, to_char(q2, 'S0999999999999999')      FROM INT8_TBL; 
!  to_char_10 |      to_char      
! ------------+-------------------
!             | +0000000000000456
!             | +4567890123456789
!             | +0000000000000123
!             | +4567890123456789
!             | -4567890123456789
! (5 rows)
! 
  SELECT '' AS to_char_11, to_char(q2, 'FM0999999999999999')     FROM INT8_TBL; 
!  to_char_11 |      to_char      
! ------------+-------------------
!             | 0000000000000456
!             | 4567890123456789
!             | 0000000000000123
!             | 4567890123456789
!             | -4567890123456789
! (5 rows)
! 
  SELECT '' AS to_char_12, to_char(q2, 'FM9999999999999999.000') FROM INT8_TBL;
!  to_char_12 |        to_char        
! ------------+-----------------------
!             | 456.000
!             | 4567890123456789.000
!             | 123.000
!             | 4567890123456789.000
!             | -4567890123456789.000
! (5 rows)
! 
  SELECT '' AS to_char_13, to_char(q2, 'L9999999999999999.000')  FROM INT8_TBL; 
!  to_char_13 |        to_char         
! ------------+------------------------
!             |                456.000
!             |   4567890123456789.000
!             |                123.000
!             |   4567890123456789.000
!             |  -4567890123456789.000
! (5 rows)
! 
  SELECT '' AS to_char_14, to_char(q2, 'FM9999999999999999.999') FROM INT8_TBL;
!  to_char_14 |      to_char       
! ------------+--------------------
!             | 456.
!             | 4567890123456789.
!             | 123.
!             | 4567890123456789.
!             | -4567890123456789.
! (5 rows)
! 
  SELECT '' AS to_char_15, to_char(q2, 'S 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 . 9 9 9') 
FROM INT8_TBL;
!  to_char_15 |                  to_char                  
! ------------+-------------------------------------------
!             |                            +4 5 6 . 0 0 0
!             |  +4 5 6 7 8 9 0 1 2 3 4 5 6 7 8 9 . 0 0 0
!             |                            +1 2 3 . 0 0 0
!             |  +4 5 6 7 8 9 0 1 2 3 4 5 6 7 8 9 . 0 0 0
!             |  -4 5 6 7 8 9 0 1 2 3 4 5 6 7 8 9 . 0 0 0
! (5 rows)
! 
  SELECT '' AS to_char_16, to_char(q2, '99999 "text" 9999 "9999" 999 "\\"text between 
quote marks\\"" 9999') FROM INT8_TBL;
!  to_char_16 |                          to_char                          
! ------------+-----------------------------------------------------------
!             |       text      9999     "text between quote marks"   456
!             |  45678 text 9012 9999 345 "text between quote marks" 6789
!             |       text      9999     "text between quote marks"   123
!             |  45678 text 9012 9999 345 "text between quote marks" 6789
!             | -45678 text 9012 9999 345 "text between quote marks" 6789
! (5 rows)
! 
  SELECT '' AS to_char_17, to_char(q2, '999999SG9999999999')     FROM INT8_TBL;
!  to_char_17 |      to_char      
! ------------+-------------------
!             |       +       456
!             | 456789+0123456789
!             |       +       123
!             | 456789+0123456789
!             | 456789-0123456789
! (5 rows)
! 
--- 111,166 ----
  --
  SELECT '' AS to_char_1, to_char(q1, '9G999G999G999G999G999'), to_char(q2, 
'9,999,999,999,999,999') 
        FROM INT8_TBL;
! ERROR:  could not access status of transaction 2686976
! DETAIL:  could not open file "/home/tgl/testversion/data/pg_clog/0002": No such file 
or directory
  SELECT '' AS to_char_2, to_char(q1, '9G999G999G999G999G999D999G999'), to_char(q2, 
'9,999,999,999,999,999.999,999') 
        FROM INT8_TBL;  
! ERROR:  could not access status of transaction 2686976
! DETAIL:  could not open file "/home/tgl/testversion/data/pg_clog/0002": No such file 
or directory
  SELECT '' AS to_char_3, to_char( (q1 * -1), '9999999999999999PR'), to_char( (q2 * 
-1), '9999999999999999.999PR') 
        FROM INT8_TBL;
! ERROR:  could not access status of transaction 2686976
! DETAIL:  could not open file "/home/tgl/testversion/data/pg_clog/0002": No such file 
or directory
  SELECT '' AS to_char_4, to_char( (q1 * -1), '9999999999999999S'), to_char( (q2 * 
-1), 'S9999999999999999') 
        FROM INT8_TBL;
! ERROR:  could not access status of transaction 2686976
! DETAIL:  could not open file "/home/tgl/testversion/data/pg_clog/0002": No such file 
or directory
  SELECT '' AS to_char_5,  to_char(q2, 'MI9999999999999999')     FROM INT8_TBL; 
! ERROR:  could not access status of transaction 2686976
! DETAIL:  could not open file "/home/tgl/testversion/data/pg_clog/0002": No such file 
or directory
  SELECT '' AS to_char_6,  to_char(q2, 'FMS9999999999999999')    FROM INT8_TBL;
! ERROR:  could not access status of transaction 2686976
! DETAIL:  could not open file "/home/tgl/testversion/data/pg_clog/0002": No such file 
or directory
  SELECT '' AS to_char_7,  to_char(q2, 'FM9999999999999999THPR') FROM INT8_TBL;
! ERROR:  could not access status of transaction 2686976
! DETAIL:  could not open file "/home/tgl/testversion/data/pg_clog/0002": No such file 
or directory
  SELECT '' AS to_char_8,  to_char(q2, 'SG9999999999999999th')   FROM INT8_TBL; 
! ERROR:  could not access status of transaction 2686976
! DETAIL:  could not open file "/home/tgl/testversion/data/pg_clog/0002": No such file 
or directory
  SELECT '' AS to_char_9,  to_char(q2, '0999999999999999')       FROM INT8_TBL; 
! ERROR:  could not access status of transaction 2686976
! DETAIL:  could not open file "/home/tgl/testversion/data/pg_clog/0002": No such file 
or directory
  SELECT '' AS to_char_10, to_char(q2, 'S0999999999999999')      FROM INT8_TBL; 
! ERROR:  could not access status of transaction 2686976
! DETAIL:  could not open file "/home/tgl/testversion/data/pg_clog/0002": No such file 
or directory
  SELECT '' AS to_char_11, to_char(q2, 'FM0999999999999999')     FROM INT8_TBL; 
! ERROR:  could not access status of transaction 2686976
! DETAIL:  could not open file "/home/tgl/testversion/data/pg_clog/0002": No such file 
or directory
  SELECT '' AS to_char_12, to_char(q2, 'FM9999999999999999.000') FROM INT8_TBL;
! ERROR:  could not access status of transaction 2686976
! DETAIL:  could not open file "/home/tgl/testversion/data/pg_clog/0002": No such file 
or directory
  SELECT '' AS to_char_13, to_char(q2, 'L9999999999999999.000')  FROM INT8_TBL; 
! ERROR:  could not access status of transaction 2686976
! DETAIL:  could not open file "/home/tgl/testversion/data/pg_clog/0002": No such file 
or directory
  SELECT '' AS to_char_14, to_char(q2, 'FM9999999999999999.999') FROM INT8_TBL;
! ERROR:  could not access status of transaction 2686976
! DETAIL:  could not open file "/home/tgl/testversion/data/pg_clog/0002": No such file 
or directory
  SELECT '' AS to_char_15, to_char(q2, 'S 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 . 9 9 9') 
FROM INT8_TBL;
! ERROR:  could not access status of transaction 2686976
! DETAIL:  could not open file "/home/tgl/testversion/data/pg_clog/0002": No such file 
or directory
  SELECT '' AS to_char_16, to_char(q2, '99999 "text" 9999 "9999" 999 "\\"text between 
quote marks\\"" 9999') FROM INT8_TBL;
! ERROR:  could not access status of transaction 2686976
! DETAIL:  could not open file "/home/tgl/testversion/data/pg_clog/0002": No such file 
or directory
  SELECT '' AS to_char_17, to_char(q2, '999999SG9999999999')     FROM INT8_TBL;
! ERROR:  could not access status of transaction 2686976
! DETAIL:  could not open file "/home/tgl/testversion/data/pg_clog/0002": No such file 
or directory

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

*** ./expected/oid.out  Thu Sep 25 02:58:06 2003
--- ./results/oid.out   Wed Nov 12 22:16:27 2003
***************
*** 41,75 ****
  (5 rows)
  
  SELECT '' AS three, o.* FROM OID_TBL o WHERE o.f1 <= '1234';
!  three |  f1  
! -------+------
!        | 1234
!        |  987
!        |    0
! (3 rows)
! 
! SELECT '' AS two, o.* FROM OID_TBL o WHERE o.f1 < '1234';
!  two | f1  
! -----+-----
!      | 987
!      |   0
! (2 rows)
! 
! SELECT '' AS four, o.* FROM OID_TBL o WHERE o.f1 >= '1234';
!  four |     f1     
! ------+------------
!       |       1234
!       |       1235
!       | 4294966256
!       |   99999999
! (4 rows)
! 
! SELECT '' AS three, o.* FROM OID_TBL o WHERE o.f1 > '1234';
!  three |     f1     
! -------+------------
!        |       1235
!        | 4294966256
!        |   99999999
! (3 rows)
! 
! DROP TABLE OID_TBL;
--- 41,47 ----
  (5 rows)
  
  SELECT '' AS three, o.* FROM OID_TBL o WHERE o.f1 <= '1234';
! server closed the connection unexpectedly
!       This probably means the server terminated abnormally
!       before or while processing the request.
! connection to server was lost

... from here down they all fail with
! psql: FATAL:  the database system is starting up

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to