On Wednesday, May 4, 2016, dandl <da...@andl.org> wrote: > I was surprised to discover that > > · CREATE OR REPLACE AGGREGATE is not allowed, but > > · CREATE OR REPLACE FUNCTION works just fine > > > > Is this an oversight, or is there some reason I missed? > > Its not an oversight: but whether it is easily accomplished, or worthy of the effort, is a different matter.
> Yes, I know I can do: > > DROP AGGREGATE IF EXISTS > > CREATE AGGREGATE > > > > But this triggers a NOTICE. Is there any convenient way to replace a > (possibly) existing aggregate function without triggering a NOTICE? > > Set client_min_messages = warning; David J.