Re: [HACKERS] Re: [GENERAL] drop/rename table and transactions

Mike Mascari wrote:
>
> Will that aid in fixing a problem such as this:
>
> session 1:
>
> CREATE TABLE example1(value int4);
> BEGIN;
>
> session 2:
>
> BEGIN;
> ALTER TABLE example1 RENAME TO example2;
>
> session 1:
>
> INSERT INTO example1 VALUES (1);
> END;
> NOTICE: Abort Transaction and not in in-progress state
> ERROR: Cannot write block 0 of example1 [test] blind
>
> session 2:
>
> END;
> NOTICE: Abort Transaction and not in in-progress state
> ERROR: Cannot write block 0 of example1 [test] blind

Seems that oid file names will fix this...
Currently, each shared buffer description structure has
database/table names for the purposes of "blind" writes
(when backend cache hasn't entry for relation and so
bufmgr can't use cache to get names from oids).
ALTER TABLE ... RENAME renames relation file(s) but doesn't
change relation name inside shbuffers...

> Mike (implicit commit) Mascari

-:)))

Vadim