Re: pg_dump problem... continued

From: "Andrew W(dot) Schmeder" <andy(at)e-molecule(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_dump problem... continued
Date: 2001-06-12 18:10:54
Message-ID: 61706.63.141.165.131.992369454.squirrel@secure.e-molecule.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Tom, Alex--
Thanks for the reply.

pg_dump from version 7.1.2 did indeed give a better error message:
getTableAttrs(): SELECT (for DEFAULT) for attr content_type_id returned 0 tuples.
Expected 1.

Also I tried to reindex the system tables... its a no-go.

xapnet_web=# reindex table pg_attribute;
NOTICE: table 'pg_attribute' wasn't reindexed
REINDEX
xapnet_web=# reindex table pg_index;
NOTICE: table 'pg_index' wasn't reindexed
REINDEX

But in the process of doing this I had to switch postgres to 'standalone' mode --
so I tried the dump again and it worked under standalone. Why? Beats me.. but my
problem is solved.

later,
andy

--
Andrew W. Schmeder
andy(at)electronicmolecule(dot)com
cell (510) 589 1407

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Szabo 2001-06-12 18:16:14 Re: select, where and null-values (or: select null<>'1' is fuzzy)
Previous Message Tom Lane 2001-06-12 18:05:36 Re: stumped on view/rule/delete problem.