Venkatesh Muthukrishnan
-
2013-11-12
- status: open --> closed-fixed
- assigned_to: Venkatesh Muthukrishnan
- Group: --> v1.0 (example)
The ChEBI SQL for use with PostgreSQL contains in "generic_dump_allstar.zip" in the code for inserts into the "structures" table an error "CONCAT():
'too many parameters:'". In PostgreSQL 9.2 the limit to the number of arguments that can be passed to a function is 100. Maybe the code can be replaced by calls to the "||" operator. This bug caused me to be unable to use the tables "structures", "autogen_structures" and "default_structures".