| 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: | Whole Thread | Raw Message | 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. |