launchpad-dev team mailing list archive
-
launchpad-dev team
-
Mailing list archive
-
Message #05774
Re: Postgres doesn't have an array_agg() function in ec2?
On Fri, Nov 19, 2010 at 10:59 AM, Gavin Panella
<gavin.panella@xxxxxxxxxxxxx> wrote:
> Running lp:~allenap/launchpad/subscribe-to-tag-bug-151129-3 through
> ec2 I get the following error several times:
>
> ProgrammingError: function array_agg(text) does not exist
> LINE 1: ...riptionFilter.id HAVING (ARRAY['crash']::TEXT[])@>ARRAY_AGG(...
> ^
> HINT: No function matches the given name and argument types. You
> might need to add explicit type casts.
>
> The failing tests all run quite happily on my local machine. Does
> anyone know enough about Postgres to have a clue why this might be
> happening?
>
> Full subunit output: http://paste.ubuntu.com/534324/
>
Is ec2 still Postgresql 8.3? This is an 8.4 feature, right?
Cheers,
deryck
--
Deryck Hodge
https://launchpad.net/~deryck
http://www.devurandom.org/
Follow ups
References