| From: | Paulo Jan <admin(at)digital(dot)ddnet(dot)es> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Creating numeric type by hand? |
| Date: | 2000-02-04 19:08:16 |
| Message-ID: | 389B23A0.5D481AD7@digital.ddnet.es |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi all:
I have Postgres 6.5.3 installed on Linux... well, sort of. The problem
is that the installation in question must be screwed up somewhere,
because I can't find the "numeric" type in it (while I can find it in
another clean 6.5.3 install), and now I need it for a project. My
question is: what do I have to do to create the type in question by
hand? I suppose that I have to connect to the "template1" database and
edit the pg_* tables... but which ones?
Of course, a possible solution would be to dump everything and
reinstall Postgres from scratch, but I can't even do a pg_dumpall in it;
it tells me:
Can not create pgdump_oid table. Explanation from backend: 'ERROR:
Relation 'pgdump_oid' already exists'.
pg_dump failed on [db_name], exiting
(If anybody can explain possible causes for this error, I'd be grateful
too).
Paulo Jan.
DDnet.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Katkin | 2000-02-04 19:44:14 | unsubscribe katkin@ling.ohio-state.edu |
| Previous Message | Ed Loehr | 2000-02-04 18:56:56 | Re: [GENERAL] using ID as a key |