| Lists: | pgsql-admin |
|---|
| From: | Patrice Beliveau <patrice(dot)beliveau(at)yahoo(dot)ca> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | cache lookup failed for type |
| Date: | 2005-12-20 14:34:58 |
| Message-ID: | 20051220143458.79923.qmail@web37011.mail.mud.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-admin |
I'm doing a very simple thing...
creating a schema xyz;
creating domain xyz.abc; (about 100)
creating table xyz.def' (abour 100)
then
drop schema xyz cascade;
after a list of
NOTICE: drop cascade to type xyz.aaa
.
.
.
I got
ERROR: cache lookup failed for type 12345
I thing that maybe there is(are) parameter(s) that need to be configure to give more cache to prevent this error
can you help me ?
---------------------------------
Lèche-vitrine ou lèche-écran ? Yahoo! Magasinage.
| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Patrice Beliveau <patrice(dot)beliveau(at)yahoo(dot)ca> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: cache lookup failed for type |
| Date: | 2005-12-21 05:00:10 |
| Message-ID: | 8986.1135141210@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-admin |
Patrice Beliveau <patrice(dot)beliveau(at)yahoo(dot)ca> writes:
> I got
> ERROR: cache lookup failed for type 12345
Show us an *exact* procedure to reproduce this, and mention exactly
which PG version you saw it on.
regards, tom lane
| From: | Jaime Casanova <systemguards(at)gmail(dot)com> |
|---|---|
| To: | Patrice Beliveau <patrice(dot)beliveau(at)yahoo(dot)ca> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: cache lookup failed for type |
| Date: | 2005-12-21 18:19:10 |
| Message-ID: | c2d9e70e0512211019l3e77cf16k53986d51e7dd7c54@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-admin |
> ERROR: cache lookup failed for type 12345
>
> I thing that maybe there is(are) parameter(s) that need to be configure to
> give more cache to prevent this error
>
> can you help me ?
>
this is not about memory... it's a bug... can you provide info about
the version that you have?
--
regards,
Jaime Casanova
(DBA: DataBase Aniquilator ;)