Because You dropped/deleted the table cache in Session A.
The simplest way to look at it is Session B was lock out when the Drop table
command was issued from Session A. Now when session B finally got its chance to
drop/delete the table it was already gone .
What kind error were you expecting
raghavendra t raagavendra@gmail.com writes:
I am facing the error cache lookup failed for relation X in Postgres-8.4.2
[ when dropping the same table concurrently in two sessions ]
Could plese tell me, why this is generated and what is the cause.
From the perspective of session B, the
Hi Justin,
Thank you for your reply..
In the future please don't cross post to multiple lists.
Appoligies for it...
Regards
Raghavendra
On Sat, Apr 3, 2010 at 10:34 PM, jus...@magwerks.com
jus...@magwerks.comwrote:
Because You dropped/deleted the table cache in Session A.
The