Improving ALTER TYPE support - Mailing list pgsql-hackers

From John Jawed
Subject Improving ALTER TYPE support
Date
Msg-id a9eb35850605231730s6dab44c5wbb66346118bac99a@mail.gmail.com
Whole thread Raw
Responses Re: Improving ALTER TYPE support
List pgsql-hackers
I've been working on a function which returns a setof a composite type. Everytime I've changed the structure of the
returningsetof, I've had to change the type accordingly, which current means doing a drop type ... cascade down to the
function.We should allow one of the following: <br /><br />1) Add a REPLACE on CREATE TYPE (create or replace type)<br
/><br/>2) Allow ALTER TYPE to alter the definition of the type (currently it only allows changes to schema and
ownership)<br/><br />It may get tricky with the first option because there'd be orphaned dependencies on objects which
referencethat particular type while it's being re-created. <br /><br />I'll work on a patch according to feedback.  

pgsql-hackers by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: Why is CVS server so slow?
Next
From: Josh Berkus
Date:
Subject: Re: Improving ALTER TYPE support