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?
**********************************************************************
