SEO

#1 (**permalink**) 04-10-2008, 10:41 AM

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...3/msg01278.php

Can you reproduce this with 8.2?

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

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

#2 (**permalink**) 04-10-2008, 10:41 AM

Hi,

On Thu, 22 Mar 2007 07:48:18 +0000
Heikki Linnakangas <heikki@enterprisedb.com> wrote:

> Can you reproduce this with 8.2?

Yes, I can.

[tanida@srapc2209 tmp]$ psql -p 54382
Welcome to psql 8.1.2 (server 8.2.3), the PostgreSQL interactive terminal.
(snip)
tanida=# \q
[tanida@srapc2209 tmp]$ pgbench -p 54382 -n -f test_function.sql -c 10 -t 100
Client 8 aborted in state 1: ERROR: relation "history" does not exist

--
TANIDA Yutaka <tanida@sraoss.co.jp>

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

#3 (**permalink**) 04-10-2008, 10:41 AM

On Thu, 22 Mar 2007 13:18:12 -0300
Jorge Godoy <jgodoy@gmail.com> wrote:

> >
> > [tanida@srapc2209 tmp]$ psql -p 54382
> > Welcome to psql 8.1.2 (server 8.2.3), the PostgreSQL interactive terminal.
> > (snip)
>
> ... is 8.*1*.2, not 8.*2*.

No. This is "Server 8.2.3" , so I connect to 8.2.3 server by 8.1.2 psql.

--
--
TANIDA Yutaka <tanida@sraoss.co.jp>

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

#4 (**permalink**) 04-10-2008, 10:41 AM

TANIDA Yutaka <tanida@sraoss.co.jp> writes:

> Hi,
>
> On Thu, 22 Mar 2007 07:48:18 +0000
> Heikki Linnakangas <heikki@enterprisedb.com> wrote:
>
>> Can you reproduce this with 8.2?
>
> Yes, I can.

This ...

>
> [tanida@srapc2209 tmp]$ psql -p 54382
> Welcome to psql 8.1.2 (server 8.2.3), the PostgreSQL interactive terminal.
> (snip)

.... is 8.*1*.2, not 8.*2*.

--
Jorge Godoy <jgodoy@gmail.com>

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

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