Re: array_agg cast issue

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Peter Neave <Peter(dot)Neave(at)jims(dot)net>
Cc: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: array_agg cast issue
Date: 2017-05-19 14:53:35
Message-ID: 27928.1495205615@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Peter Neave <Peter(dot)Neave(at)jims(dot)net> writes:
> For some reason when I restored a version of array_agg was brought with it.
> ...
> I simply ran
> DROP AGGREGATE public.array_agg(anyelement);
> and my problem has been fixed.

Ah, cool. You might want to check and see if any other unwanted copies
of system functions are there too ...

regards, tom lane

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Fran G 2017-05-25 00:37:18 Serializable Isolation Level
Previous Message Peter Neave 2017-05-19 06:59:13 Re: array_agg cast issue