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.

Reply via email to