Re: Changing types without DROP...CASCADE

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: "Bawer Dagdeviren" <bawer(at)pucpac(dot)com>, <pgadmin-hackers(at)postgresql(dot)org>
Subject: Re: Changing types without DROP...CASCADE
Date: 2006-05-19 12:27:20
Message-ID: E7F85A1B5FF8D44C8A1AF6885BC9A0E40138832D@ratbert.vale-housing.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

> -----Original Message-----
> From: pgadmin-hackers-owner(at)postgresql(dot)org
> [mailto:pgadmin-hackers-owner(at)postgresql(dot)org] On Behalf Of
> Bawer Dagdeviren
> Sent: 19 May 2006 12:15
> To: pgadmin-hackers(at)postgresql(dot)org
> Subject: [pgadmin-hackers] Changing types without DROP...CASCADE
>
> Hi!

Hi,

> My name is Bawer Dagdeviren, I currently work as a developer
> for a small firm in Sweden, mainly creating web-applications
> in the dotNet-Framework.
> I'm new to this list and I have been using pgAdmin for some time now.
> It's a really good product, so I'd like to see some features
> added and generally help with development whenever I have
> time to spare.
>
> I'll start with a question:
> Have you guys thought about making it possible to alter a
> type definition (CREATE TYPE) without having to
> DROP...CASCADE on all stored procedures using that type? I
> have missed this feature too many times now that I would like
> to help implement it, or at least make the issue known if it isn't.
>
> Essentially what need to happen is a DROP...CASCADE of all
> functions using that type and then recreating them again,
> right? What do you think?

I think that this particular case is probably not that interesting to
most people (though that is not to say it shouldn't be done) - the more
common case is already on the TODO list as:

- Recreate views after column type change

Both are essentially the same problem, and as there may be more similar
cases that haven't yet been considered (or may only appear in future
releases of PostgreSQL), it seems to me that a relatively generic
mechanism for rebuilding dependent objects should be implemented. I
don't have time to look at this myself right now, but if you want to
please do, and feel free to post any questions you may have.

Regards, Dave.

Responses

Browse pgadmin-hackers by date

  From Date Subject
Next Message Bawer Dagdeviren 2006-05-20 21:00:09 Re: Changing types without DROP...CASCADE
Previous Message Bawer Dagdeviren 2006-05-19 11:14:30 Changing types without DROP...CASCADE