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

Re: DROP COLUMN round 4

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
Cc: "Hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: DROP COLUMN round 4
Date: 2002-07-30 22:51:07
Message-ID: 22720.1028069467@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
"Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)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

In response to

Responses

pgsql-hackers by date

Next:From: Curt SampsonDate: 2002-07-30 23:21:09
Subject: Re: WAL file location
Previous:From: Thomas LockhartDate: 2002-07-30 22:50:12
Subject: Re: WAL file location

pgsql-patches by date

Next:From: Bruce MomjianDate: 2002-07-31 01:06:43
Subject: Re: small psql patch - show Schema name for \dt \dv \dS
Previous:From: Bruce MomjianDate: 2002-07-30 22:32:18
Subject: Re: START TRANSACTION

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