error with pg_dump in 6.3.2

Поиск
Список
Период
Сортировка
От wstotts@sonitrol.net
Тема error with pg_dump in 6.3.2
Дата
Msg-id XFMail.991019083139.wstotts@sonitrol.net
обсуждение исходный текст
Ответ на Missing RPM for 6.5.2 ?  (Alain TESIO <alain_tesio@yahoo.com>)
Список pgsql-general
Hi all...
I'm having some difficulty dumping a 50,000 record table containing 2 images held
as large objects in each record. Following is the error I am getting:

$pg_dump -vod -t invoice_data -f invoice_data.dmp acct_invoice

--  maximum system oid is 10898729
--  last builtin oid is 17184
--  reading user-defined types
--  reading user-defined functions
--  reading user-defined aggregates
--  reading user-defined operators
--  reading user-defined tables
--  reading table inheritance information
--  finding the attribute names and types for each table
--  finding the attrs and types for table: invoice_data
--  finding the attrs and types for table: fixit
--  finding the attrs and types for table: tom_data
--  flagging inherited attributes in subtables
--  dumping out tables
--  dumping out the contents of one of 3 tables
--  dumping out the contents of Table invoice_data
--  reading indices information
getIndices(): SELECT failed  <--------------------error occurs here


The database stucture is as follows:
Database    = acct_invoice
 +------------------+----------------------------------+----------+
 |  Owner           |             Relation             |   Type   |
 +------------------+----------------------------------+----------+
 | invoice          | fixit                            | table    |
 | invoice          | invoice_data                     | table    |
 | invoice          | onepage                          | index    |
 | invoice          | tom_data                         | table    |
 +------------------+----------------------------------+----------+

Table    = fixit
+----------------------------------+----------------------------------+-------+
|              Field               |              Type                | Length|
+----------------------------------+----------------------------------+-------+
| invoice_no                       | int4                             |     4 |
+----------------------------------+----------------------------------+-------+
Table    = invoice_data
+----------------------------------+----------------------------------+-------+
|              Field               |              Type                | Length|
+----------------------------------+----------------------------------+-------+
| invoice_no                       | int4                             |     4 |
| date                             | date                             |     4 |
| po                               | text                             |   var |
| terms                            | text                             |   var |
| custid                           | int4                             |     4 |
| addrcustid                       | int4                             |     4 |
| name                             | text                             |   var |
| addr1                            | text                             |   var |
| addr2                            | text                             |   var |
| citystate                        | text                             |   var |
| amtdue                           | text                             |   var |
| dbid                             | int4                             |     4 |
| page_no                          | int2                             |     2 |
| jpeg                             | oid                              |     4 |
| ps                               | oid                              |     4 |
| file                             | text                             |   var |
+----------------------------------+----------------------------------+-------+

Table    = onepage
+----------------------------------+----------------------------------+-------+
|              Field               |              Type                | Length|
+----------------------------------+----------------------------------+-------+
| invoice_no                       | int4                             |     4 |
| page_no                          | int2                             |     2 |
| dbid                             | int4                             |     4 |
+----------------------------------+----------------------------------+-------+

Table    = tom_data
+----------------------------------+----------------------------------+-------+
|              Field               |              Type                | Length|
+----------------------------------+----------------------------------+-------+
| tom_acct                         | text                             |   var |
| tom_div                          | text                             |   var |
| tom_alpha                        | text                             |   var |
| tom_cust_name                    | text                             |   var |
| tom_addr1                        | text                             |   var |
| tom_addr2                        | text                             |   var |
| tom_city                         | text                             |   var |
| tom_state                        | text                             |   var |
| tom_zip                          | text                             |   var |
| tom_pos                          | text                             |   var |
| tom_pos2                         | text                             |   var |
| tom_billto                       | text                             |   var |
| tom_company                      | text                             |   var |
| tom_other                        | text                             |   var |
| tom_other_desc                   | text                             |   var |
| tom_other_cycle                  | text                             |   var |
| tom_phone                        | text                             |   var |
| tom_dice_ar                      | text                             |   var |
+----------------------------------+----------------------------------+-------+

If anyone can point me in the right direction to get past this error, please email
me direct as well as posting to the list. Thanks!!
Bill Stotts




**********************************************************************
Bill Stotts                     |  Voice: 860-616-7535
wstotts@sonitrol.net            |    Fax: 860-616-7589
Sonitrol Communications Corp.   |
                                |
_SONITROL_ Expect the best...   |  Where do you want to GO tomorrow?
**********************************************************************

В списке pgsql-general по дате отправления:

Предыдущее
От: Ted Florence
Дата:
Сообщение: Macintosh drivers
Следующее
От: Can BICAN
Дата:
Сообщение: problem with procedural languages