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@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