Indexes created when insert blobs--problems!

From: Nick Urbanik <nicku(at)vtc(dot)edu(dot)hk>
To: pgsql-general(at)postgresql(dot)org
Cc: nicku(at)iohk(dot)com
Subject: Indexes created when insert blobs--problems!
Date: 1999-03-02 08:56:18
Message-ID: Pine.LNX.4.04.9903021646490.20218-100000@nickpc.tyee.vtc.edu.hk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Dear folks,
we have a strange problem. When pg_dump'ing our database with photographs
inserted as binary large objects, we found that many indexes were unable
to be dumped; the error message complained that the particular index was
not associated with any table, and pg_dump gave up.

Now are these indexes are not created by postgres 6.3.2, but they are with
6.4.2. The index name starts with xinx followed by the oid of the BLOB.
Is this normal? Why does pg_dump fail? Please CC to both of my email
addresses as well as to the list.

Nick Urbanik, Dept. of Electrical & Communications Engineering
Hong Kong Institute of Vocational Education (Tsing Yi)
email: nicku(at)vtc(dot)edu(dot)hk, nicku(at)iohk(dot)com
Tel: (852) 2436 8660, (825) 2436 8674 Fax: (852) 2436 8643

Browse pgsql-general by date

  From Date Subject
Next Message Brian Burton-Cundall 1999-03-02 11:15:19 NEWBIE: How do I use \copy to populate from a flat file
Previous Message Peter Blazso 1999-03-01 21:55:00 Re: pwman is now more available ... :-)