DROP FUNCTION of multiple functions

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема DROP FUNCTION of multiple functions
Дата
Msg-id 6dcd1248-4631-a4c1-65d7-b873fbcada6c@2ndquadrant.com
обсуждение исходный текст
Ответы Re: DROP FUNCTION of multiple functions
Re: DROP FUNCTION of multiple functions
Список pgsql-hackers
Here is a patch series that implements several changes in the internal
grammar and node representation of function signatures.  They are not
necessarily meant to be applied separately, but they explain the
progression of the changes nicely, so I left them like that for review.

The end goal is to make some user-visible changes in DROP FUNCTION and
possibly other commands that refer to functions.

With these patches, it is now possible to use DROP FUNCTION to drop
multiple functions at once: DROP FUNCTION func1(), func2(), func3().
Other DROP commands already supported that, but DROP FUNCTION didn't
because the internal representation was complicated and couldn't handle it.

The next step after this would be to allow referring to functions
without having to supply the arguments, if the name is unique.  This is
an SQL-standard feature and would be very useful for dealing "business
logic" functions with 10+ arguments.  The details of that are to be
worked out, but with the help of the present changes, this would be a
quite localized change, because the grammar representation is well
encapsulated.

--
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Indirect indexes
Следующее
От: Mithun Cy
Дата:
Сообщение: Re: Patch: Implement failover on libpq connect level.