Sean Chittenden wrote:
I'v find out that this error occurs in:
dependency.c file
2004-04-26 11:09:34 ERROR: dependency.c 1621: cache lookup of
relation
149064743 failed
2004-04-26 11:09:34 ERROR: Relation "tmp_table1" does not exist
2004-04-26 11:09:34 ERROR: Relation "tmp_table1" does not exi
Sean Chittenden wrote:
I'v find out that this error occurs in:
dependency.c file
2004-04-26 11:09:34 ERROR: dependency.c 1621: cache lookup of relation
149064743 failed
2004-04-26 11:09:34 ERROR: Relation "tmp_table1" does not exist
2004-04-26 11:09:34 ERROR: Relation "tmp_table1" does not exis
temp tables don't use the shared buffer cache, how can this be
related to the BG writer?
Don't the system catalogs use the shared buffer cache?
BEGIN;
SELECT create_temp_table_func(); -- Inserts a row into pg_class via
CREATE TEMP TABLE
-- Do other stuff
COMMIT; -- After the commit, the ro
I'v find out that this error occurs in:
dependency.c file
2004-04-26 11:09:34 ERROR: dependency.c 1621: cache lookup of
relation
149064743 failed
2004-04-26 11:09:34 ERROR: Relation "tmp_table1" does not exist
2004-04-26 11:09:34 ERROR: Relation "tmp_table1" does not exist
in getRelationDescr
[Renames thread from "The Pepsi Challenge" to "The PostgreSQL
Challenge"]
But, I am suspecting that it's a race condition with the new
background
writer code.
Why? Have you demonstrated that the failure does not occur in 7.4?
What other operations have been added to HEAD that would allow for
s
Sean Chittenden <[EMAIL PROTECTED]> writes:
> But, I am suspecting that it's a race condition with the new background
> writer code.
Why? Have you demonstrated that the failure does not occur in 7.4?
> psql:test-end2.sql:3: ERROR: cache lookup failed for relation 398033
> CONTEXT: SQL query "
I'v find out that this error occurs in:
dependency.c file
2004-04-26 11:09:34 ERROR: dependency.c 1621: cache lookup of relation
149064743 failed
2004-04-26 11:09:34 ERROR: Relation "tmp_table1" does not exist
2004-04-26 11:09:34 ERROR: Relation "tmp_table1" does not exist
in getRelationDescrip
