Tom Lane wrote: > Peter Wilson <petew@xxxxxxxxxxxxxxxx> writes: >> pg_restore : [custom archiver] Dumping a specific TOC data block out of order is >> not supported without ID on this input stream (fseek required). > > Could you show us the unmodified output from pg_restore -l, as well as > the edits you made to produce the -L script? > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match > Raw output from pg_restore -l is as follows: ================================= ; ; Archive created at Mon Nov 27 01:35:56 2006 ; dbname: whitebeam ; TOC Entries: 24 ; Compression: 9 ; Dump Version: 1.10-0 ; Format: CUSTOM ; Integer: 4 bytes ; Offset: 8 bytes ; Dumped from database version: 8.1.4 ; Dumped by pg_dump version: 8.1.4 ; ; ; Selected TOC Entries: ; 1656; 0 0 SEQUENCE SET public audit_id_seq whitebeam 1657; 0 0 SEQUENCE SET public collection_id_seq whitebeam 1658; 0 0 SEQUENCE SET public contacts_contact_id_seq whitebeam 1659; 0 0 SEQUENCE SET public files_file_id_seq whitebeam 1660; 0 0 SEQUENCE SET public items_item_id_seq whitebeam 1661; 0 0 SEQUENCE SET public searchtree_node_id_seq whitebeam 1654; 0 89555 TABLE DATA public audit whitebeam 1652; 0 43231 TABLE DATA public collection_types whitebeam 1653; 0 43243 TABLE DATA public collections whitebeam 1639; 0 43140 TABLE DATA public contact_att whitebeam 1649; 0 43203 TABLE DATA public contact_item whitebeam 1650; 0 43208 TABLE DATA public contact_node whitebeam 1638; 0 43131 TABLE DATA public contacts whitebeam 1646; 0 43185 TABLE DATA public files whitebeam 1643; 0 43165 TABLE DATA public item_files whitebeam 1641; 0 43154 TABLE DATA public item_leafs whitebeam 1647; 0 43194 TABLE DATA public item_prices whitebeam 1644; 0 43169 TABLE DATA public itemdata whitebeam 1645; 0 43178 TABLE DATA public items whitebeam 1648; 0 43199 TABLE DATA public node_leafs whitebeam 1640; 0 43146 TABLE DATA public searchtree whitebeam 1651; 0 43213 TABLE DATA public site whitebeam 1642; 0 43158 TABLE DATA public stockdata whitebeam ================================= The re-ordered version is: ================================= ; ; Archive created at Mon Nov 27 01:35:56 2006 ; dbname: whitebeam ; TOC Entries: 24 ; Compression: 9 ; Dump Version: 1.10-0 ; Format: CUSTOM ; Integer: 4 bytes ; Offset: 8 bytes ; Dumped from database version: 8.1.4 ; Dumped by pg_dump version: 8.1.4 ; ; ; Selected TOC Entries: ; 1656; 0 0 SEQUENCE SET public audit_id_seq whitebeam 1657; 0 0 SEQUENCE SET public collection_id_seq whitebeam 1658; 0 0 SEQUENCE SET public contacts_contact_id_seq whitebeam 1659; 0 0 SEQUENCE SET public files_file_id_seq whitebeam 1660; 0 0 SEQUENCE SET public items_item_id_seq whitebeam 1661; 0 0 SEQUENCE SET public searchtree_node_id_seq whitebeam 1638; 0 43131 TABLE DATA public contacts whitebeam 1645; 0 43178 TABLE DATA public items whitebeam 1639; 0 43140 TABLE DATA public contact_att whitebeam 1649; 0 43203 TABLE DATA public contact_item whitebeam 1650; 0 43208 TABLE DATA public contact_node whitebeam 1646; 0 43185 TABLE DATA public files whitebeam 1643; 0 43165 TABLE DATA public item_files whitebeam 1647; 0 43194 TABLE DATA public item_prices whitebeam 1644; 0 43169 TABLE DATA public itemdata whitebeam 1640; 0 43146 TABLE DATA public searchtree whitebeam 1648; 0 43199 TABLE DATA public node_leafs whitebeam 1641; 0 43154 TABLE DATA public item_leafs whitebeam 1642; 0 43158 TABLE DATA public stockdata whitebeam 1652; 0 43231 TABLE DATA public collection_types whitebeam 1653; 0 43243 TABLE DATA public collections whitebeam 1654; 0 89555 TABLE DATA public audit whitebeam 1651; 0 43213 TABLE DATA public site whitebeam ================================= Pete
