| 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: | Whole Thread | Raw Message | 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 |