This was first described here: http://moodle.org/mod/forum/discuss.php?d=28163#134386
PostgreSQL appears to truncate table names when assigning id's.
mdl_assignment_submissions id becomes
mdl_dialogue_conversations id becomes
[Also reported this as a separate bug under the assignment component.]
Throws errors - affects backup/restore, import data; not sure what else.