From: | Joseph Shraibman <jks(at)selectacast(dot)net> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: error on drop table |
Date: | 2001-11-29 00:08:16 |
Message-ID: | 3C057C70.1060306@selectacast.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
>
--
Joseph Shraibman
jks(at)selectacast(dot)net
Increase signal to noise ratio. http://www.targabot.com
From | Date | Subject | |
---|---|---|---|
Next Message | Roderick A. Anderson | 2001-11-29 00:10:48 | Warm Fuzzy Feeling! |
Previous Message | Tom Lane | 2001-11-28 23:59:49 | Re: error on drop table |