Improving ALTER TYPE support
| От | John Jawed |
|---|---|
| Тема | Improving ALTER TYPE support |
| Дата | |
| Msg-id | a9eb35850605231730s6dab44c5wbb66346118bac99a@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re: Improving ALTER TYPE support
|
| Список | 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 по дате отправления: