pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
cache lookup failed for type
3+ messages / 3 participants
[nested] [flat]

* cache lookup failed for type
@ 2005-12-20 14:34  Patrice Beliveau <patrice.beliveau@yahoo.ca>
  0 siblings, 2 replies; 3+ messages in thread

From: Patrice Beliveau @ 2005-12-20 14:34 UTC (permalink / raw)
  To: 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.

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: cache lookup failed for type
@ 2005-12-21 05:00  Tom Lane <tgl@sss.pgh.pa.us>
  parent: Patrice Beliveau <patrice.beliveau@yahoo.ca>
  1 sibling, 0 replies; 3+ messages in thread

From: Tom Lane @ 2005-12-21 05:00 UTC (permalink / raw)
  To: Patrice Beliveau <patrice.beliveau@yahoo.ca>; +Cc: pgsql-admin

Patrice Beliveau <patrice.beliveau@yahoo.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



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: cache lookup failed for type
@ 2005-12-21 18:19  Jaime Casanova <systemguards@gmail.com>
  parent: Patrice Beliveau <patrice.beliveau@yahoo.ca>
  1 sibling, 0 replies; 3+ messages in thread

From: Jaime Casanova @ 2005-12-21 18:19 UTC (permalink / raw)
  To: Patrice Beliveau <patrice.beliveau@yahoo.ca>; +Cc: 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 ;)



^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2005-12-21 18:19 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-12-20 14:34 cache lookup failed for type Patrice Beliveau <patrice.beliveau@yahoo.ca>
2005-12-21 05:00 ` Tom Lane <tgl@sss.pgh.pa.us>
2005-12-21 18:19 ` Jaime Casanova <systemguards@gmail.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox