misc/migration/2.45.0_Any.py
author Adrien Di Mascio <Adrien.DiMascio@logilab.fr>
Mon, 29 Jun 2009 16:09:49 +0200
branchstable
changeset 2192 529edb6a6c96
parent 1977 606923dff11b
permissions -rw-r--r--
[repository] do not rollback when freeing pool. This shouldn't be necessary and brings a not-so-small overhead when the page makes a lot of queries

# following functions have been renamed, but keep old definition for bw compat
"""

:organization: Logilab
:copyright: 2001-2009 LOGILAB S.A. (Paris, FRANCE), license is LGPL v2.
:contact: http://www.logilab.fr/ -- mailto:contact@logilab.fr
:license: GNU Lesser General Public License, v2.1 - http://www.gnu.org/licenses
"""
sql('''CREATE AGGREGATE group_concat (
  basetype = anyelement,
  sfunc = array_append,
  stype = anyarray,
  finalfunc = comma_join,
  initcond = '{}'
)''')

sql('''CREATE FUNCTION text_limit_size (fulltext text, maxsize integer) RETURNS text AS $$
BEGIN
    RETURN limit_size(fulltext, 'text/plain', maxsize);
END
$$ LANGUAGE plpgsql;
''')


synchronize_rschema('bookmarked_by')