Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: "Relation not found" error but table exits.
- 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: Thu, 22 Mar 2007 07:48:18 +0000
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" againstexists 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
- Follow-Ups:
- Re: "Relation not found" error but table exits.
- From: TANIDA Yutaka
- Re: "Relation not found" error but table exits.
- References:
- "Relation not found" error but table exits.
- From: TANIDA Yutaka
- "Relation not found" error but table exits.
- Prev by Date: BUG #3182: Cannot make libpq with BCC 5.5
- Next by Date: BUG #3183: set maximum row to retrieve + postgresql.conf
- Previous by thread: "Relation not found" error but table exits.
- Next by thread: Re: "Relation not found" error but table exits.
- Indexes: