Postgres Pro
Downloads
Home   >   mailing lists

Re: error on drop table - Mailing list pgsql-general

From Joseph Shraibman
Subject Re: error on drop table
Date
Msg-id 3C057C70.1060306@selectacast.net
Whole thread Raw
In response to error on drop table  (Joseph Shraibman <jks@selectacast.net>)
List pgsql-general
Tree view 
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@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

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Casting Varchar to Numeric
Next
From: Joseph Shraibman
Date:
Subject: Re: error on drop table