Re: [GENERAL] cache lookup of relation 165058647 failed

2004-04-14 Thread Juris Krumins
On Wed, 14 Apr 2004, Richard Huxton wrote: > On Wednesday 14 April 2004 10:35, Juris Krumins wrote: > > > 2004-04-14 12:24:54 [74021] LOG: query: SELECT d.config_id, d.text1 as > > text, d.field_name, > > 2004-04-14 12:24:54 [74021] LOG: duration: 0.005295 sec > > 2004-04-14 12:24:54 [74021]

Re: [GENERAL] cache lookup of relation 165058647 failed

2004-04-14 Thread Tom Lane
Juris Krumins <[EMAIL PROTECTED]> writes: > So bacicaly we have only 4 places, which cane generate errors like that, > and all this places refer to HeapTupleIsValid function. Hmm. What's even more interesting is that none of them are in places that I would expect to be called during a CREATE TABL

Re: [GENERAL] cache lookup of relation 165058647 failed

2004-04-14 Thread Tom Lane
Richard Huxton <[EMAIL PROTECTED]> writes: > The error is complaining about a relation that used to have an OID of > 165058647. This is almost certainly a temporary table. Are there any plpgsql > functions referring to a temporary table, or do you create, drop, recreate > tmp_table1 within the s

Re: [GENERAL] cache lookup of relation 165058647 failed

2004-04-14 Thread Juris Krumins
On Wed, 14 Apr 2004, Tom Lane wrote: > Richard Huxton <[EMAIL PROTECTED]> writes: > > The error is complaining about a relation that used to have an OID of > > 165058647. This is almost certainly a temporary table. Are there any plpgsql > > functions referring to a temporary table, or do you creat