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@selectacast.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@selectacast.net
Increase signal to noise ratio. http://www.targabot.com
