Re: "Relation not found" error but table exits.

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