error with pg_dump in 6.3.2

From: wstotts(at)sonitrol(dot)net
To: pgsql-general(at)postgreSQL(dot)org
Subject: error with pg_dump in 6.3.2
Date: 1999-10-19 12:31:39
Message-ID: XFMail.991019083139.wstotts@sonitrol.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)sonitrol(dot)net | Fax: 860-616-7589
Sonitrol Communications Corp. |
|
_SONITROL_ Expect the best... | Where do you want to GO tomorrow?
**********************************************************************

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Can BICAN 1999-10-19 14:23:43 problem with procedural languages
Previous Message Ted Florence 1999-10-19 11:55:38 Macintosh drivers