Postgres Pro
Downloads
Home   >   mailing lists

Re: "Relation not found" error but table exits. - Mailing list pgsql-bugs

From Heikki Linnakangas
Subject Re: "Relation not found" error but table exits.
Date
Msg-id 460234C2.4020909@enterprisedb.com
Whole thread Raw
In response to "Relation not found" error but table exits.  (TANIDA Yutaka <tanida@sraoss.co.jp>)
Responses Re: "Relation not found" error but table exits.
List pgsql-bugs
Tree view 
TANIDA Yutaka wrote:
> Hi,
>
> My customer found a problem about PL/pgsql functions and TRUNCATE command.
> If you execute PL/pgsql function includeing TRUNCATE command concurrently,
> causes "relation ... does not exist." or "relation with OID XXXXX does not exist" against
> exists table.
> ...
> In my tests , this bug affect at least 7.4 or above. 7.3.x doesn't affect because
> TRUNCATE can't execute from a function. But I don't know whether other commands
> such as CLUSTER have this bug.

This looks very similar to this report from yesterday:

http://archives.postgresql.org/pgsql-hackers/2007-03/msg01278.php

Can you reproduce this with 8.2?

--
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com

pgsql-bugs by date:

Previous
From: TANIDA Yutaka
Date:
Subject: "Relation not found" error but table exits.
Next
From: "msmbarabino@virgilio.it"
Date:
Subject: Re: Very slow bytea extraction