On Wed, 1 Oct 2014, Stephan Eggermont wrote:

> >YourSchemaMirror class >> schema
> >
> >    ^’schema_name’
> >
> >Schema mirrors mirror the functions in your database and provide an interface to call them. There is a little tool to inspect the >differences between the methods of the schema mirror and the functions in
> the database, which can be invoked by:
> >
> >YourSchemaMirror browseChanges
> 
> The default schema that was created is 'public'.
> 
> When trying to browseChanges on that, I get back
> a 'function array_accum(text) does not exist' in a 
> Pg3ErrorResponse. (Postgres 9.3.5 on Mac 10.7.5)

That's right. The query we use to get the defined functions in a schema 
uses that aggregate function. We always add it to our databases, because 
it's really useful. It's from 
http://www.postgresql.org/docs/9.3/static/xaggr.html and the definition 
is

CREATE AGGREGATE array_accum (anyelement)
(
     sfunc = array_append,
     stype = anyarray,
     initcond = '{}'
);

But I've uploaded a new version of PostgresV3-CodeMirror, which doesn't 
use that function anymore, so it should work with the default Postgres 
installation.


Levente

> 
> Stephan
> 
>