Re: error on drop table

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

In response to

Browse pgsql-general by date

  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