Re: error on drop table

To reproduce:

create table table1 ( list text, ukey int);
insert into table1 values( '1', 1);
insert into table1 values( '2', 2);
insert into table1 values( '3', 3);
insert into table1 values( '4', 4);
insert into table1 values( '5', 5);

SELECT list,ukey INTO temporary tqt FROM table1;
BEGIN;
DECLARE cname CURSOR FOR SELECT list, ukey FROM tqt ;
FETCH 10 from cname;
DROP TABLE tqt;
END;

Tom Lane wrote:

> Joseph Shraibman <jks(at)selectacast(dot)net> writes:
>
>>NOTICE: FlushRelationBuffers(tqt, 0): block 0 is referenced (private 1, global 1)
>>ERROR: heap_drop_with_catalog: FlushRelationBuffers returned -2
>>
>
> Hmm, can you provide a sequence to reproduce this?
>
> regards, tom lane
>

--
Joseph Shraibman
jks(at)selectacast(dot)net
Increase signal to noise ratio. http://www.targabot.com