Hi.
Short question: is postgresql with 1.1.1 supported? As stated on the
webpage it is (Mysql OR Postgresql).
So I started to configure it according to the docs via apt. But I got
stuck on:
# baruwa-admin syncdb --noinput
# for name in $(echo "accounts messages lists reports status fixups config");
do
baruwa-admin migrate $name;
done
It fails with:
File "/usr/lib/pymodules/python2.6/south/migration/migrators.py", line 57, in
<lambda>
return (lambda: direction(orm))
File
"/usr/lib/pymodules/python2.6/baruwa/config/migrations/0003_initial_sql.py",
line 16, in forwards
db.execute_many(open(configsql).read())
File "/usr/lib/pymodules/python2.6/south/db/generic.py", line 168, in
execute_many
self.execute(st)
File "/usr/lib/pymodules/python2.6/south/db/generic.py", line 150, in execute
cursor.execute(sql, params)
File
"/usr/lib/pymodules/python2.6/django/db/backends/postgresql_psycopg2/base.py",
line 44, in execute
return self.cursor.execute(query, args)
django.db.utils.DatabaseError: syntax error at or near "IGNORE"
LINE 1: INSERT IGNORE INTO scanner_config_sections (id, name) values...
and
db.execute_many(open(signaturesql).read())
File "/usr/lib/pymodules/python2.6/south/db/generic.py", line 168, in
execute_many
self.execute(st)
File "/usr/lib/pymodules/python2.6/south/db/generic.py", line 150, in execute
cursor.execute(sql, params)
File
"/usr/lib/pymodules/python2.6/django/db/backends/postgresql_psycopg2/base.py",
line 44, in execute
return self.cursor.execute(query, args)
django.db.utils.DatabaseError: syntax error at or near "rule"
LINE 2: ...\t%signature-dir%/users/html/", auth_user.id, ".html") rule,
Postgresql doesn't support INSERT IGNORE or CONCAT so the errors are quite
right.
So postgresql isn't really a choice for 1.1.1 right?
Thanks
Veit
_______________________________________________
Keep Baruwa FREE - http://pledgie.com/campaigns/12056
