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
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. |