--------------Boundary-00=_HJ9NEX45RN4MSKRDLVBZ
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 8bit

On Saturday 01 February 2003 14:00, Tom Lane wrote:
> What was the query it failed on, exactly?  That last page it read
> seems to be an empty index page --- it should have moved on to the
> next index page, I'd think, rather than doing anything that could
> hang up.

Here's the log.  As you can see, nothing was logged after the COPY command.

It's possible that the file was corrupted.  I will do a new test from scratch 
now that I am not switching speeds.

-- 
D'Arcy J.M. Cain <darcy@{druid|vex}.net>   |  Democracy is three wolves
http://www.druid.net/darcy/                |  and a sheep voting on
+1 416 425 1212     (DoD#0082)    (eNTP)   |  what's for dinner.

--------------Boundary-00=_HJ9NEX45RN4MSKRDLVBZ
Content-Type: text/x-log;
  charset="iso-8859-1";
  name="pg.log"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment; filename="pg.log"

Feb  1 04:21:17 matrix pg_test[7432]: [3] DEBUG:  connection: host=192.168.10.75 user=darcy database=cert
Feb  1 04:21:17 matrix pg_test[7432]: [4] DEBUG:  InitPostgres
Feb  1 04:21:17 matrix pg_test[7432]: [5] DEBUG:  StartTransactionCommand
Feb  1 04:21:17 matrix pg_test[7432]: [6] DEBUG:  query: select getdatabaseencoding()
Feb  1 04:21:17 matrix pg_test[7432]: [7] DEBUG:  ProcessQuery
Feb  1 04:21:17 matrix pg_test[7432]: [8] DEBUG:  CommitTransactionCommand
Feb  1 04:21:17 matrix pg_test[7432]: [9] DEBUG:  StartTransactionCommand
Feb  1 04:21:17 matrix pg_test[7432]: [10] DEBUG:  query: SELECT usesuper FROM pg_user WHERE usename = 'darcy'
Feb  1 04:21:17 matrix pg_test[7432]: [11] DEBUG:  ProcessQuery
Feb  1 04:21:17 matrix pg_test[7432]: [12] DEBUG:  CommitTransactionCommand
Feb  1 04:21:17 matrix pg_test[7432]: [13] DEBUG:  StartTransactionCommand
Feb  1 04:21:17 matrix pg_test[7432]: [14] DEBUG:  query: UPDATE "pg_class" SET "reltriggers" = 0 WHERE "relname" = 'certificate';
Feb  1 04:21:17 matrix pg_test[7432]: [15] DEBUG:  ProcessQuery
Feb  1 04:21:17 matrix pg_test[7432]: [16] DEBUG:  CommitTransactionCommand
Feb  1 04:21:17 matrix pg_test[7432]: [17] DEBUG:  StartTransactionCommand
Feb  1 04:21:17 matrix pg_test[7432]: [18] DEBUG:  query: COPY "certificate" FROM stdin;
Feb  1 04:21:17 matrix pg_test[7432]: [19] DEBUG:  ProcessUtility: COPY "certificate" FROM stdin;

--------------Boundary-00=_HJ9NEX45RN4MSKRDLVBZ--