During migration:

krtek:/opt/redmine/redmine-1.0# export LANG=C; rake redmine:migrate_from_trac RAILS_ENV="production"
(in /opt/redmine/redmine-1.0)

WARNING: a new project will be added to Redmine during this process.
Are you sure you want to continue ? [y/N] y                        

Trac directory []: /var/lib/trac/dm_library/
Trac database adapter (sqlite, sqlite3, mysql, postgresql) [sqlite]: sqlite3
Trac database encoding [UTF-8]: 
Target project identifier []: dmlibrary

Migrating components..............
Migrating milestones.........
Migrating custom fields..
Migrating tickets................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................
Migrating wiki..................................................................................rake aborted!
SQLite3::SQLException: near "a": syntax error: SELECT DISTINCT attachment.* FROM attachment WHERE attachment.type = 'wiki' AND attachment.id = 'Jak nauczyć Visual Studio obsługiwać Boost'a'

(See full trace by running task with --trace)
2010-11-28 17:17:46-17:26:20 export LANG=C; rake redmine:migrate_from_trac RAILS_ENV="production" # 1

current software:
2010-11-28 17:43:30 export RAILS_ENV="production"
krtek:/opt/redmine/redmine-1.0# ruby script/about
About your application's environment
Ruby version 1.8.7 (i486-linux)
RubyGems version 1.3.4
Rack version 1.0
Rails version 2.3.5
Active Record version 2.3.5
Active Resource version 2.3.5
Action Mailer version 2.3.5
Active Support version 2.3.5
Application root /opt/redmine/redmine-1.0
Environment production
Database adapter postgresql
Database schema version 20100705164950

About your Redmine plugins
Redmine Charts 0.1.0
Screenshot Paste 1.1.0
Stuff To Do Plugin 0.4.0
Redmine Graphs plugin 0.1.0
2010-11-28 17:43:37 ruby script/about

I use 8.3.11-0lenny1 version of postgresql.