| From: | raghavendra t <raagavendra(dot)rao(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org, pgsql-performance(at)postgresql(dot)org |
| Subject: | ERROR: cache lookup failed for relation X |
| Date: | 2010-04-03 16:38:11 |
| Message-ID: | h2xbc7de5a31004030938v82d1c243k27be011f9a681f76@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-performance |
Hi All,
I am facing the error "cache lookup failed for relation X" in Postgres-8.4.2
version. As you all know, its a reproducable and below is the example.
This can be generated with two sessions;
Am opening two sessions here Session A and Session B
Session A
=========
step 1 - creating the table
postgres=# create table cache(id integer);
step 2 - Create the trigger and the function on particular table
postgres=# CREATE FUNCTION cachefunc() RETURNS trigger AS $$
BEGIN
RETURN NEW;
END; $$ LANGUAGE plpgsql;
postgres=# CREATE TRIGGER cachetrig BEFORE INSERT ON cache FOR EACH ROW
EXECUTE PROCEDURE cachefunc();
Step 3 - Inserting a row in a table
postgres=# insert into cache values (1);
Step 4 - Droping the table in BEGIN block and issuing the same drop in
another session B
postgres=# begin;
postgres=# drop table cache;
step 5 - Open the second session B and issue the same command
postgres=# drop table cache; --- In session B, this will wait untill commit
is issued by the Session A.
step 6 - Issue the commit in Session A
postgres=# commit;
Step -7 now we can the see the error in the session B
ERROR: cache lookup failed for relation X
Could plese tell me, why this is generated and what is the cause.
Thanks in advance
Regards
Raghavendra
| From | Date | Subject | |
|---|---|---|---|
| Next Message | justin@magwerks.com | 2010-04-03 17:04:57 | Re: ERROR: cache lookup failed for relation X |
| Previous Message | Tom Lane | 2010-04-03 16:17:26 | Re: count function alternative in postgres |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | justin@magwerks.com | 2010-04-03 17:04:57 | Re: ERROR: cache lookup failed for relation X |
| Previous Message | Guillaume Lelarge | 2010-04-03 11:58:35 | Re: How much memory is PostgreSQL using |