| From: | Heikki Linnakangas <heikki(at)enterprisedb(dot)com> |
|---|---|
| To: | TANIDA Yutaka <tanida(at)sraoss(dot)co(dot)jp> |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: "Relation not found" error but table exits. |
| Date: | 2007-03-22 07:48:18 |
| Message-ID: | 460234C2.4020909@enterprisedb.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-hackers |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Murali | 2007-03-22 09:07:47 | BUG #3183: set maximum row to retrieve + postgresql.conf |
| Previous Message | CN Liou | 2007-03-22 06:45:40 | BUG #3182: Cannot make libpq with BCC 5.5 |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hannu Krosing | 2007-03-22 09:03:24 | Re: Fixing hash index build time |
| Previous Message | Grzegorz Jaskiewicz | 2007-03-22 07:15:09 | Re: [PATCHES] Bitmapscan changes |