| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Riyad Aufari <raufari(at)yahoo(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Error when entering template1 |
| Date: | 2005-07-26 13:26:07 |
| Message-ID: | 26989.1122384367@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Riyad Aufari <raufari(at)yahoo(dot)com> writes:
> I have been using postgresql (7.2.1-5) for several
> years. Supprisingly, I've just got a problem when
> doing pg_dumpall.
> The error is :
> psql: ERROR: getTypeOutputInfo: Cache lookup of type
> 0 failed
> This error also occurs when i enter to postgres using
> this command:
> psql template1
If it's just template1 that's corrupt, you could drop it and recreate it
from template0 --- see
http://techdocs.postgresql.org/techdocs/pgsqladventuresep1.php
This assumes you have no valuable data in template1, but I suppose you
would have noticed the problem sooner if you did.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-07-26 13:44:53 | Re: Access FE - This operation is not supported within transaction |
| Previous Message | Tom Lane | 2005-07-26 13:14:22 | Re: Trigger disactivation and SELECT WAITING |