From: | Dave Page <dpage(at)postgresql(dot)org> |
---|---|
To: | Euler Taveira de Oliveira <euler(at)timbira(dot)com> |
Cc: | pgadmin-hackers(at)postgresql(dot)org |
Subject: | Re: bug when dropping parent table |
Date: | 2007-09-18 07:26:57 |
Message-ID: | 46EF7DC1.9060803@postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-hackers |
Euler Taveira de Oliveira wrote:
> Dave Page wrote:
>
>> I'm beginning to think that we need to try to maintain a list of
>> dependent objects within each object (perhaps by OID), and when we drop
>> or alter anything, we scan the tree for dependencies and refresh as
>> appropriate. I'm worried that could be expensive, but at least it should
>> be possible now that the refresh function is able to retain the node
>> state. This isn't a project for 1.8 though.
>>
> I have to agree with you. This is not for 1.8. Your idea of maitaining a
> list of dependent objects is good but too expensive. Another idea is to
> query the pg_depend to get all the dependencies (imitating the DROP ...
> CASCADE code) before drop the target object. So we could scan the tree
> for these dependencies and remove them too.
That sounds like a fine idea :-). I'll give it some thought.
/D
From | Date | Subject | |
---|---|---|---|
Next Message | svn | 2007-09-20 15:40:22 | SVN Commit by dpage: r6653 - trunk/pgadmin3/pgadmin/ctl |
Previous Message | Euler Taveira de Oliveira | 2007-09-18 00:06:59 | Re: bug when dropping parent table |