I don't have a test script for you yet, but it appears the problem is that I declared a
cursor on the temp table and dropped it before I did the END on the block that I declared
the cursor in. I'm working on the test script.
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
Increase signal to noise ratio. http://www.targabot.com
In response to
pgsql-general by date
|Next:||From: Roderick A. Anderson||Date: 2001-11-29 00:10:48|
|Subject: Warm Fuzzy Feeling!|
|Previous:||From: Tom Lane||Date: 2001-11-28 23:59:49|
|Subject: Re: error on drop table |