Re: DROP COLUMN round 4 - Mailing list pgsql-hackers

From Tom Lane
Subject Re: DROP COLUMN round 4
Date
Msg-id 22720.1028069467@sss.pgh.pa.us
Whole thread Raw
In response to DROP COLUMN round 4  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
List pgsql-hackers
"Christopher Kings-Lynne" <chriskl@familyhealth.com.au> writes:
> 1. It cascade deletes objects, but it _always_ cascades, no matter what
> behaviour I specify.  Also, it doesn't give me indications that it's cascade
> deleted an object.

Would you give a specific example?

> + drop table child;
> + ERROR:  RelationForgetRelation: relation 143905 is still open

> What's with the RelationForgetRelation error???  Am I not closing some
> handle somewhere?

AlterTableDropColumn neglects to heap_close the relation, but I'm
surprised that error isn't reported sooner.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Thomas Lockhart
Date:
Subject: Re: WAL file location
Next
From: Curt Sampson
Date:
Subject: Re: WAL file location