On Wednesday, May 4, 2016, dandl <
david@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.