| 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 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Curt Sampson | 2002-07-30 23:21:09 | Re: WAL file location |
| Previous Message | Thomas Lockhart | 2002-07-30 22:50:12 | Re: WAL file location |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2002-07-31 01:06:43 | Re: small psql patch - show Schema name for \dt \dv \dS |
| Previous Message | Bruce Momjian | 2002-07-30 22:32:18 | Re: START TRANSACTION |