Re: [BUGS] "Relation not found" error but table exits.

2007-03-26 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 > This also ties into the discussions we've had off-and-on about making > catalog lookups behave in an MVCC fashion instead of using SnapshotNow. > I'm still pretty hesitant to go there, but maybe we could do something > involving MVCC for unloc

Re: [BUGS] "Relation not found" error but table exits.

2007-03-26 Thread Jorge Godoy
TANIDA Yutaka <[EMAIL PROTECTED]> writes: > Hi, > > On Thu, 22 Mar 2007 07:48:18 + > Heikki Linnakangas <[EMAIL PROTECTED]> wrote: > >> Can you reproduce this with 8.2? > > Yes, I can. This ... > > [EMAIL PROTECTED] tmp]$ psql -p 54382 > Welcome to psql 8.1.2 (server 8.2.3), the PostgreSQL

Re: [BUGS] "Relation not found" error but table exits.

2007-03-22 Thread TANIDA Yutaka
On Thu, 22 Mar 2007 13:18:12 -0300 Jorge Godoy <[EMAIL PROTECTED]> wrote: > > > > [EMAIL PROTECTED] 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 ser

Re: [BUGS] "Relation not found" error but table exits.

2007-03-22 Thread Tom Lane
TANIDA Yutaka <[EMAIL PROTECTED]> writes: > 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 X does not > exist" against > exist

Re: [BUGS] "Relation not found" error but table exits.

2007-03-22 Thread Tom Lane
TANIDA Yutaka <[EMAIL PROTECTED]> writes: > If you execute PL/pgsql function includeing TRUNCATE command concurrently, > causes "relation ... does not exist." or "relation with OID X does not > exist" against > exists table. Do you still see this in 8.2? regards, tom

Re: [BUGS] "Relation not found" error but table exits.

2007-03-22 Thread TANIDA Yutaka
Hi, On Thu, 22 Mar 2007 07:48:18 + Heikki Linnakangas <[EMAIL PROTECTED]> wrote: > Can you reproduce this with 8.2? Yes, I can. [EMAIL PROTECTED] tmp]$ psql -p 54382 Welcome to psql 8.1.2 (server 8.2.3), the PostgreSQL interactive terminal. (snip) tanida=# \q [EMAIL PROTECTED] tmp]$ pgbenc

Re: [BUGS] "Relation not found" error but table exits.

2007-03-21 Thread Heikki Linnakangas
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 X does not exist" against exists table. ... In my test

[BUGS] "Relation not found" error but table exits.

2007-03-21 Thread TANIDA Yutaka
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 X does not exist" against exists table. Here's a testcase to reproduce this.