Postgres Pro
Downloads
Home   >   mailing lists

Re: [NOVICE] array_agg cast issue - Mailing list pgsql-novice

From Tom Lane
Subject Re: [NOVICE] array_agg cast issue
Date
Msg-id 27928.1495205615@sss.pgh.pa.us
Whole thread Raw
In response to Re: [NOVICE] array_agg cast issue  (Peter Neave <Peter.Neave@jims.net>)
Responses Re: [NOVICE] array_agg cast issue  (pinker <pinker@onet.eu>)
List pgsql-novice
Tree view 
Peter Neave <Peter.Neave@jims.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

pgsql-novice by date:

Previous
From: Peter Neave
Date:
Subject: Re: [NOVICE] array_agg cast issue
Next
From: Fran G
Date:
Subject: [NOVICE] Serializable Isolation Level