Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

Next:From: Roderick A. AndersonDate: 2001-11-29 00:10:48
Subject: Warm Fuzzy Feeling!
Previous:From: Tom LaneDate: 2001-11-28 23:59:49
Subject: Re: error on drop table

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group