DROP FUNCTION of multiple functions - Mailing list pgsql-hackers

From Peter Eisentraut
Subject DROP FUNCTION of multiple functions
Date
Msg-id 6dcd1248-4631-a4c1-65d7-b873fbcada6c@2ndquadrant.com
Whole thread Raw
Responses Re: DROP FUNCTION of multiple functions
Re: DROP FUNCTION of multiple functions
List 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

Attachment

pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Indirect indexes
Next
From: Mithun Cy
Date:
Subject: Re: Patch: Implement failover on libpq connect level.