On Tue, Sep 21, 2010 at 3:10 PM, Jens Wilke wrote:
> On Dienstag, 21. September 2010, Aleksey Tsalolikhin wrote:
>
>> So PostgreSQL was trying to lookup a row in a system table and
>> did not find it in a cache.
>
> yes,
> select * from pg_type where oid =14237017
Thank you.
>>> Did you alter
On Dienstag, 21. September 2010, Aleksey Tsalolikhin wrote:
Hi Aleksey,
> So PostgreSQL was trying to lookup a row in a system table and
> did not find it in a cache.
yes,
select * from pg_type where oid =14237017
>> Did you alter a type before?
> No. I don't even know how to alter a type.
On Tue, Sep 21, 2010 at 2:06 PM, Jens Wilke wrote:
> On Dienstag, 21. September 2010, Aleksey Tsalolikhin wrote:
>> Yesterday, I had twelve thousand "cache lookup failed for type N"
>> messages, like this:
>
>> What does "type 14237017" mean?
>
> pg_type oid
Dear Jens,
I am trying to understa
On Dienstag, 21. September 2010, Aleksey Tsalolikhin wrote:
> Yesterday, I had twelve thousand "cache lookup failed for type N"
> messages, like this:
> What does "type 14237017" mean?
pg_type oid
> What cache are we talking about?
Did you alter a type before?
There's a bug in postgres, tha
"Kevin Martins" <[EMAIL PROTECTED]> writes:
> I've been working with SRF and i want to return a setof record but i
> keep getting this error ´cache lookup failed for type 18867840´
That seems unlikely to be related to the code you've shown us.
Have you tried back-tracing from errfinish() to find
. I will try to locate the corrupted row(s), maybe
pg_filedump can help with that.
Regards // Mike
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Saturday, 26 May 2007 9:38 AM
To: Michael Harris (BR/EPA)
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] ERROR: cache
"Michael Harris \(BR/EPA\)" <[EMAIL PROTECTED]> writes:
> None of the typeid atttypid fields were 0:
Hmm, but you've got a couple of bigint-array columns:
>167581 | pmtransmittedcarrierpower | 1016 |-1 |
> -1 | 4 |0 | -1 |-1 | f| x
> | d
--Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Friday, 25 May 2007 11:52 PM
To: Michael Harris (BR/EPA)
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] ERROR: cache lookup failed for type 0
"Michael Harris \(BR/EPA\)" <[EMAIL PROTECTED]> writes:
>
"Michael Harris \(BR/EPA\)" <[EMAIL PROTECTED]> writes:
> Whenever any kind of query is done on the table below, this is the
> result:
> ispdb_vxe=> select * from pm.carrier_on_13642;
> ERROR: cache lookup failed for type 0
Hmm, seems like something happened to your system catalogs, but where
ex
Greg Stark <[EMAIL PROTECTED]> writes:
> Tom Lane <[EMAIL PROTECTED]> writes:
>> You didn't palloc the values array. Any reasonable compiler would have
>> warned you about that BTW. If you don't have compiler warnings enabled,
>> learn to use them.
> I think with gcc this type of warning is only
Tom Lane <[EMAIL PROTECTED]> writes:
> Tzahi Fadida <[EMAIL PROTECTED]> writes:
> > well, I tried the heap_deformtuple and I am getting now:
> > select testgetrows();
> > server closed the connection unexpectedly
>
> You didn't palloc the values array. Any reasonable compiler would have
> warned
005 12:24 AM
> To: Tzahi Fadida
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] ERROR: cache lookup failed for type 0
>
>
> Tzahi Fadida <[EMAIL PROTECTED]> writes:
> > well, I tried the heap_deformtuple and I am getting now: select
> > testgetrows(
Tzahi Fadida <[EMAIL PROTECTED]> writes:
> well, I tried the heap_deformtuple and I am getting now:
> select testgetrows();
> server closed the connection unexpectedly
You didn't palloc the values array. Any reasonable compiler would have
warned you about that BTW. If you don't have compiler war
tx->lRel, AccessShareLock);
SRF_RETURN_DONE(funcctx);
}
}
Regards,
tzahi.
> -Original Message-
> From: Tom Lane [mailto:[EMAIL PROTECTED]
> Sent: Friday, January 07, 2005 10:31 PM
> To: Tzahi Fadida
> Cc: pgsql-general@postgresql.org
> Subject:
Tzahi Fadida <[EMAIL PROTECTED]> writes:
> It still doesn't work. btw, I am using 8rc2.
Um. The "clean" way to do this is to use BlessTupleDesc and then
heap_formtuple. That requires you to break down the original tuple
into fields (see heap_deformtuple). Alternatively you could poke
the dataty
i Fadida
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] ERROR: cache lookup failed for type 0
>
>
> Tzahi Fadida <[EMAIL PROTECTED]> writes:
> > Hi, I am learning how to use the c functions and my function below
> > works when I do: select testgetrow
Tzahi Fadida <[EMAIL PROTECTED]> writes:
> Hi, I am learning how to use the c functions and my function below works
> when I do:
> select testgetrows();
> but when I do select * from testgetrows(); I am getting:
> "ERROR: cache lookup failed for type 0"
> Whats's the problem?
I don't think it's s
17 matches
Mail list logo
